Creating a top/bottom filter

The top/bottom filter restricts your results to a range you choose. For example, you can create reports such as the ticket type with the shortest resolution time or the five agents with the most solved tickets.

Note: You can also add top/bottom filters to a dashboard, so viewers can view the highest or lowest results in each report. See Displaying the highest and lowest values.

This article discusses the two ways to create a top/bottom filter:

• Top/bottom result manipulation
• Top/bottom attribute calculation

Top/bottom result manipulation

The top/bottom result manipulation is a simple way to break down a report into the highest and lowest results.

To apply this filter

1. In the report builder, click the result manipulation icon ().
2. In the Result Manipulation panel, click Top/bottom.
3. Enter the number of top and bottom results you would like to see.
4. Select the metric to use.
5. Select a 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 individually, you should select the per block strategy. If you select Auto, Explore will automatically choose a location.

   

6. Optionally, select a calculation option:
   • Aggregate values: Useful if you have attributes in both the Rows and Columns panels, or a chart displaying results over time. Aggregate values calculate 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 another category. This is useful when you don't want to view the details of the smaller results, but still want the overall totals and percentage shares to be accurate. Works only with the COUNT, SUM, MIN, and MAX aggregators.
7. Click Apply.

The top/bottom result manipulation is added to the Filters panel.

Top/bottom attribute calculation

If you want a 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 reports created from the data source.

Note: Top/bottom attributes can't be used on reports where decompose or drill in are configured. An error occurs if a user attempts to decompose or drill into a report with a top/bottom attribute. If you're planning to configure decompose or drill in on a report, use the top/bottom result manipulation instead.

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:

To create a top/bottom calculation

1. In the report builder, click the calculations icon ().
2. Select the Top/bottom attribute option.
3. Select a metric and an aggregator.
4. Select the number of top and bottom values to display.
5. Select an attribute.

   

6. If you have any filters applied to the metrics and attributes of your report, check Compute according to the filters in the report to apply the filters to the attribute as well.
7. Click Save
8. Add your attribute to either the Columns or Rows panels.