You can sort dimensions visible in the Measures and Dimensions
panel by the number of times each dimension value occurs in a dataset.
Sorting dimensions does not affect the data displayed in a visualization.
- Select the Horizontal Orientation
icon on the Measures and Dimensions panel.
- Display the number of occurrences:
- Position the pointer over the dimension to filter.
- Select the Options
icon, and select Show Measure
and Occurrences.
The number of occurrences appears beside each dimension value in the
column.
- Sort by occurrence:
- Position the pointer over the dimension that you selected in step 2.
- Select the Options
icon, and select Sort by Measure Lowest to
Highest or Sort by Measure Highest to
Lowest.
Data in the dimension column is sorted by occurrence.