Limit displayed values in a data element (Beta)

🚩

This documentation describes a public beta feature and is under construction. This page should not be considered part of our published documentation until this notice, and the corresponding Beta flag on the feature in the Sigma service, are removed. As with any beta feature, the feature discussed below is subject to quick, iterative changes. The latest experience in the Sigma service might differ from the contents of this document.

Beta features are subject to the Beta features disclaimer.

You can limit which values are displayed for a column in a grouped table, pivot table, or chart.

For example, to only show the top 3 performing stores in each store region in a pivot table, you can limit the displayed stores to the top 3 sorted by total products sold:

Different from a Top N filter , limiting the display values lets you change which values are displayed without affecting the calculated totals and other values.

Limit the display values

To limit which values are displayed in a grouped table, pivot table, or chart, do the following:

1. Select the down arrow (), then select Transform > Limit display values.

2. For Display, choose whether to display the top or bottom number of values, and enter a number.

   For example, choose to display the bottom 10 values, and group the remaining values into an "Others" category.

3. For by, choose the function to use to order the aggregated column. Choose one of Rank, RankDense, or RowNumber.

4. For Sort by, select a column to sort the column by when choosing the top or bottom number of values. If the column is not aggregated, choose a function to aggregate by.

5. Click Done.

   If you chose to aggregate an unaggregated column, Sigma creates a grouping for your table with the column with limited display values as the group by column, and the aggregated column as the calculation in the grouping.

If you limit the display values in a pivot row or table columns, the Others category is added to the end of the list of columns.

Remove a limit

After limiting display values, you can remove the limit:

1. For a column with display values limited, select the down arrow () to open the column menu, then select Transform > Limit display values.
2. In the Limit display values modal, select Remove limit.

Limitations

• You can only limit the display values of Text columns. Other data types, such as Number or Date, are not supported.
• If you change the sort order of the column used for to limit the display values, the values in the "Others" category change according to the sort because the Rank and RankDense functions rely on the sort order.