Filtering results
By filtering the results that are displayed in a report, you can remove unnecessary data and focus on the data that is significant to you. If you save the changes, the report will contain these updates the next time that you open it.
About this task
If there is a lot of data in a bar or line chart that causes some of the data to not display by default, you can use the horizontal scroll bar on the X-axis to view the rest of the data. There is also a filter icon to filter the data based on the text on labels.
The table at the bottom of the chart also includes a lot of information. So, now, the tabular data is presented in pages. There is also the filter icon to filter the data in the table.
Procedure
- To filter the data in a report, open that report.
-
Click the Menu icon
and click Edit.
-
On the graph or table, click the Settings icon
.
-
On the View Settings page, in the Filter section, select one of the following options and
specify the values:
Option Description Filter by count Display the specified number of items. For example, if you select this option and then type 15, the report will show the 15 items with the highest values (Show highest values) or the 15 items with the lowest values (Show lowest values). Filter by value Display items based on a comparison with the specified value. For example, if you select this option and then type 15, the report will show all of the items that are higher than 15 (Show counters above filter values) or lower than 15 (Show counters below filter value). Filter by name Display items that match the specified name. If you are filtering a table, the label is usually a page, and is listed in the left column. If you are filtering a graph, the label is a legend in the graph. See the changes in the Preview section. -
Click the Apply button.
If you are filtering a table by count or value, the Primary counter for table filtering lists the counters in the heading of the table that you are filtering. Select a primary counter. If a value is removed by the primary filter, all other data occupying the same row as the removed value is also removed, thus maintaining the integrity of the results.