When working in Tables and Metrics, you can filter your views to make them better for Boards or Charts. This article will discuss how to use Filters in Pigment.
Table of Contents
How to Access and identify Filters
From within either a Metric or table, you can activate a filter by clicking on the Filter icon and selecting +Add a Filter. Once a filter is applied, you will see the number of filters next to this same icon.
Select the dimension you want to filter
After you select + Add a filter, you have to use the drop-down to decide which dimension you want to filter. Only dimensions in Rows or Columns can be filtered. After you choose the dimension you want to filter, you can filter by directly entering the items or by basing it off of the metric’s value.
Filtering by Items
Filtering by Items will allow you to select items from within that dimension list you want to either Include or Exclude items from that dimension. You can apply these filters to all dimensions that are present in Columns or Rows.
If you select Include it will only show those items. For example, if a filter is set to Filter Product where Items include Product A the result will be that only Product A is shown.
If you select Exclude it will only remove those items. For example, if a filter is set to Filter Product where Items exclude Product A the result will be that only Product A is the only item not present. When choosing these options it's important to think of the future of the list. When using the exclude option, all new items will be down.
Filtering by Metric Value
Metric value allows you to filter items depending on the value that is present within the cells. When using Metric values, your options are dependent on how your Pivot configuration is set up. In order to be eligible for filtering by Metric Value, the dimension that you want to filter must be in the bottom position for either Columns or Rows.
Eligible dimensions for Filtering examples
In the example to the right, you would be able to select the Metric value for the Month or the Scenario dimension.
Operators in Filters
After you choose which dimension, you want to filter, you will have to choose an operator such as =, <,> and enter a value on which to base those operators. These are dependent on the item type, for example, operators such as Contains exist for text data types metrics.
Identifying Item specifics from opposite Dimensions
When using a Metric value, you must identify the specific items from the dimensions opposite of the filtered dimension. This means if your filtered dimension is in Rows, you have to show the specifics for the dimensions in the Columns and vice versa. The position of these is determined by the Pivot panel.
In this example, the Products dimension is in Rows, the Country and Month dimensions are in Columns. If you want to filter off multiple items from the opposite dimensions, you can create multiple Filters.
Hiding empty rows or columns
When working with Metrics or Tables, you can hide empty columns or rows if they have no data. From within the filter, you’ll see Show empty rows and columns. Click on this dropdown and you can see there are multiple options. You can hide empty rows or columns either separately or together to make your data easier to find.