Searching the Maximum Value Within a Certain Time Period

Preview

You can display the maximum value within a certain period. For example, the template execution log records the number of template accesses per day. You want to display the number of accesses of the date with the highest number of visits within that period.

Implementation Method

The effect can be achieved through Indicator Condition and Filter. You can use Indicator Condition to select the number of records for the current day, use Filter to find the day with the highest number of accesses within that period, and display the number of accesses for that day in the component.

You can download the sample data: Record Number.xlsx

Procedures

KPI Card Creation

1. Drag the indicator field Count into Indicator, as shown in the following figure.

2. Set Chart Type to KPI Card, as shown in the following figure.

Indicator Condition Setting

1. Click the  icon next to the field Count and select Indicator Condition from the drop-down list, as shown in the following figure.

2. On the indicator condition setting page, click Add Condition, select the field Date as a time period, and set the time period to the dynamic time of the current day. Click OK to filter the number of access records for the current day, as shown in the following figure.

Filter Setting

1. Drag the field Date into Filter and select Day, as shown in the following figure.

2. On the filtering condition page, set the condition to Top N, Fixed Value, and 1 in sequence, and click OK.

Effect Display

The following figure shows the number of access records for the day with the highest number of visits within a period.