Sorting and Limiting Data

You can sort the data elements within your chart by the available metrics or attributes. You can also limit the amount of data that is displayed to show a more detailed view of your data.

When sorting your data, the options vary based on whether you have metrics or attributes and what type of chart style you are using, as sorting and limiting is not available for all chart styles. Administrators and users with editing rights to data source configurations can also set the default sort order and limits from the Data Sources page. For additional information, see Managing Data Source Configurations.

For metric-based charts, you can sort in ascending or descending order. For attribute-based charts, you can sort in alphabetical or reverse-alphabetical order. For time attribute-based charts, you can sort in chronological or reverse-chronological order.

To sort or limit your data:

  1. Click in the upper right corner of the chart to display the chart drop-down menu.
  2. Select Sort & Limit from the drop-down menu. The Sort & Limit sidebar becomes available.
  3. Select a category to sort by from the drop-down menu.
  4. Depending on the type of data elements your chart is based on, different sorting options are displayed. Select a sorting type, for example, Descending or Ascending.
  5. If you want to limit the amount of data displayed on your chart, enter a number in the Limit field.
  6. Click Apply to apply the sort and limit options.