Freeform tables in Analysis Workspace are the foundation for interactive data analysis. As such, they can contain thousands of rows of information. Filtering and sorting the data can be a critical part of efficiently surfacing the most important information.
Filters in Analysis Workspace help you surface the most important information.
To filter data in Freeform tables:
In a Freeform table, hover over the column that contains the data you want to filter.
Select the Filter icon when it appears.
In the Search word or phrase field, specify a word or phrase that you want to filter by. Only rows that contain the word or exact phrase specified are shown.
(Optional) To filter by different criteria or by multiple criteria, select Show advanced.
The following options are available
|Include unspecified (none)||Select this option to show data in the table that does not fall into any of the dimensions of the table.|
Choose If all criteria are met to show only data that meets all the criteria that you specify. This option typically results in more refined data.
Choose If any criteria are met to show data that meets any one of the filter criteria that you specify. This option typically results in less refined data.
Select from the following filter options:
(Select Add row to add multiple filter criteria. The option you select in the Match section determines whether all or any of the criteria that you add must be met.)
|Always exclude items||Specify the name of any items that you want to exclude from the filtered data.|
Select Apply to filter the data.
The Filter icon turns blue when a filter is applied to the table.
You can sort the data of a Freeform table by any column in Analysis Workspace that is a Metric.
A down arrow icon is visible in the header of the column that data is currently being sorted by.
To sort the data in a Freeform table by a particular column:
Hover over the column title by which you want to sort the data.
Select the down arrow icon when it appears.
Table data is sorted by the column you selected.