Skip to main content
All CollectionsData VisualisationTables
Sorting by Multiple Columns
Sorting by Multiple Columns

Learn how to sort reports using multiple dimensions and metrics

Updated over 2 weeks ago

Users are able to sort their data by multiple metrics and dimensions to make it easier to understand, analyse and visualise data in reports.

Sort report by one Colum:

  • On the Report builder, users can use the 'Sort & Limit' feature

  • Alternatively users can click the metric / dimension column in the 'preview window'

Users will be able to see an arrow located near the metric / dimension, the arrow indicates how the report has been sorting (ascending or descending).

Sort by Multiple Columns:

To sort by more than one column, hold down the alt/option key on your keyboard and click which fields you want to sort by. Click again on the field to change the direction from descending to ascending.

This table is sorted firstly by Market and Impressions.

To view the table sort settings, click the cog icon on the upper right hand side of the report and select 'visualisation' from the list. A pop up box will open that will show the table sort settings. This will allow you to view the order of what metrics and dimensions are being sorted along with the direction for each. You can also access this feature in the Report Builder by clicking on the visualisation type in the left menu.

You can also change the priority of the sorting by clicking on the 6 dots icon beside the metric or dimension name, and dragging to the top of the list. Also add additional columns to sort.


Please note that you can only use multi sorting for the default table visualisation.


Did this answer your question?