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 either a Dimension or a Metric.
A down arrow icon is visible in the header of the column that data is currently being sorted by.
In any Freeform table in Analysis Workspace, click the arrow next to the name of the Dimension or Metric.
Consider the following when sorting: