Sorting columns

ADVANCED TOOLS

Unpivoted data in an Explore is sorted by default according to the following prioritization: 

1. The first date dimension, descending 

2. If no date dimension exists, the first measure, descending 

3. If no measure exists, the first added dimension, ascending 

A field's sort order is indicated in several ways: 

• An arrow next to the field name indicating the sorting direction (pointed up for ascending or down for descending)  

• A pop-up that appears when you hover over a field name with a number indicating the sort-by order 

Sort columns 

You may want to sort data differently than the default order. Sort by clicking on a field heading in the data table to sort the query by that field: 

• Click a field heading once to sort by that field in descending order. 

• Click a field heading twice to sort that field in ascending order. 

Sort by multiple columns 

To sort multiple columns, hold down the Shift key and then click the column headers in the order you want them sorted. 

When you're sorting a column containing a pivoted measure, rows with values in that column are sorted first, followed by rows without data in that column. 

EXAMPLE  

The arrows next to Total Spend and Impressions indicate that the table is sorted by both fields, and the order by which the table is sorted. In the following example, the table is sorted first by Total Spend (descending order) and then by Impressions (descending order).