查找某个时间段内的最大值

1. Overview

1.1 Expected effect

Display the maximum value within a certain period of time. For example, "FRDemo_SALES_BASIC" records the sales volume, and we want to display the month with the most sales of the year.

1.2 Implementation ideas

Through detail filtering and result filter together. First use the detail filtering to filter out the counter of sales of the year, and then use the result filter to find the time period with the highest number of sales of the month, and display the counter in that time period in the component.

2. Example

Use "FRDemo_SALES_BASIC" data.

2.1 Operation steps

2.1.1 Make indicator card

1) Drag the indicator field "Counter" to the vertical axis, as shown in the figure below:

2) Select the "kpi indicator card", as shown in the figure below:

2.1.2 Set detail filtering

1) For the indicator field "Counter", select "drop-down>Detail Filtering", as shown in the figure below:

2) Enter the detail filtering setting box, add filter conditions. Select "Date" in "time period", and set the dynamic time as the"Year Start". Click "OK" to filter out the number of visits during the year 2010, as shown in the figure below:

2.1.3 Set result filter

1) Drag the "Date" field into the result filter, and click "drop-down> More Groups> month", as shown in the figure below:

2) Select "drop-down>Filter", as shown in the figure:

3) Enter the filter setting page, select "add condition", filter out the largest number of value, and click "OK". As shown below:

2.2 Effect view

The month with the most sales of the year is shown in the figure below: