Sorting Data in Visuals

There are several ways in which you can sort the data displayed in a visual.

The available sorting options depend on the type of visual.

To sort field values:

Click , the Dashboards tab.
Click Dashboard Designer, in the bottom-left corner.
On the Analyses dialog, click , the Options button, next to an existing analysis and select Edit.
On the analysis page, select a visual.
Click , the Visualize button, on the toolbar to display the Visuals panel.
In the Visuals panel, use the Options menu next to a field to sort data.
- To sort the values in a field in ascending or descending order, click , the Options button, next to the field, then select Sort order and Ascending or Descending.
- To sort data based on another field from the visual, click , the Options button, next to a field, then select Sort by and choose one of the fields from the list.
- To sort data based on a field that is not included in the visual, click , the Options button, next to a field, then select Sort by ⇒ Off-visual field....
  On the Off-visual field panel, select the field that you want to sort by and the aggregation method, set the sort order, and click Apply.

In visuals that display field labels, you can also sort data directly from the visual. Hover over a field label and click the sort icon or click

, the Options button, and select a sorting option from the menu.