The top/bottom filter restricts your results to the highest or lowest results. For example, you can create queries such as the ticket type with the shortest resolution time or the five agents with the most solved tickets. This can be useful if you have several results, but your chart type functions best with a smaller number.
This article discusses the two ways to create a top/bottom filter:
Top/bottom result manipulation
The top/bottom result manipulation is a simple way to break down a report into the highest and lowest results.
- In the Query Builder, click the Result manipulation icon ().
- Select the Top bottom option.
- Enter the number of top and bottom results you would like to see.
- Select the metric to use.
- Select your strategy.
If you have attributes on both Rows and Columns, you can select the appropriate section. If you have multiple attributes, and would like to see the top/bottom for each individual, you should select the per block strategy. If you select Auto, Explore will automatically choose a location.
- Select from the optional two calculation options:
- Aggregate values Useful if you have attributes on both Rows and Columns or a chart displaying results over time. Aggregate values will execute the calculation on the total of the metric's results, instead of on the first concurrence of the metric.
- Aggregate filtered elements All results outside your specified top/bottom range will be combined into an other category. This is useful when you do not want to view the details of the smaller results, but still would like the overall totals and percentage shares to be accurate.
- Click Apply.
Your top/bottom result manipulation will automatically be added to the Filters bar.
Top/bottom attribute calculation
If you want your top/bottom filter to apply to other metrics than those on the frame, you can use a top/bottom attribute. Top/bottom attributes can be used in all queries created from the dataset.
For example, if you want to analyze the number of tickets solved by the assignees with the longest full resolution times, you could use a top/bottom attribute. Your report would resemble the image below:
- In the Query Builder, click the Calculation engine icon ().
- Select the Top/bottom attribute option.
- Select your metric and aggregator.
- Select the number of top and bottom values to display.
- Select an attribute.
- If you have any filters applied to the metrics and attributes of your query, check Compute according to the filters in this query to apply the filters to the attribute as well.
- Click Save
- Add your attribute to either Columns or Rows.