VisibilityLimit

The VisibilityLimit function limits the values displayed in a column to the number of specified values according to an order calculated by one of the Rank (default), RankDense, or RowNumber functions. The order used by the ranking function relies on the sort applied to the data element.

This function is used to limit displayed values in a data element. For more granular control over which values are displayed, such as to specify the bottom N values or choose a specific aggregate values column in a pivot table to use to sort the output column, see Limit displayed values in a data element.

Syntax

VisibilityLimit(output, limit, [rank_type])

Function arguments

Notes

• Use this function with sorted, aggregated data.
• You cannot use the function multiple times in one formula. For example, attempting to concatenate values with a formula like the following is not supported:
  VisibilityLimit([PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA/Store Region], 3) & VisibilityLimit([Store State], 4)

Example

In a pivot table with pivot rows of Store Region and Store Name, and a values column Total Sold, you can limit the store names to the top 3 in each region:

VisibilityLimit([Store Name], 3)

In this case, the ranking function is applied to the Store Name column, and displays the first three stores alphabetically, grouping the remainder into an Others category.

If you want to display the top 3 stores by total amount sold, sort the Total Sold column descending.

If you want to specify a different column to use for the ranking function, limit the visibility of displayed values from the column details menu. See Limit displayed values in a data element (Beta).