Sort by metric

Last update: December 9, 2024

Topics:
Data Warehouse

CREATED FOR:

User
Admin

Provides ranked breakdown reports in Data Warehouse, sorted by descending metric value.

Sorting by metric makes Data Warehouse reports easier for you to interpret, and makes these reports easier to compare with other Analytics breakdown reporting views.

The following shows how enabling the “Metrics Sort” option will reorder rows in a Data Warehouse report.

There are four possible ways that Data Warehouse reports may be organized with “Metrics Sort”, based on how date granularity, reporting dimensions, or metrics are configured, and whether “Max rows” is set:

Layout 1: Line items are sorted in dictionary order (default). If “Max rows” is set, only the first N rows are provided in the report.
Layout 2: Data Warehouse applies a metric sort over all rows in the report. Ties in the first metric value are broken by the 2nd metric, and then the 3rd, and so on. When all metrics are tied, the standard dictionary ordering of breakdown line items is applied.
Layout 3: As Layout 2, with only the top N rows (i.e., the number set in “max rows”) being output in the report.
Layout 4: As Layout 2, with the exception that line items for each date granularity period are grouped together and sorted within that respective time range.

Please reference the “Report layout” column in this table to determine how “Metrics Sort” interacts with other Data Warehouse reporting options.

Sort by Metric?	Has Metrics?	Has Breakdowns?	Date Granularity?	Max rows set?	Report Layout
No	Yes or No	Yes or No	Yes or No	Yes or No	1
Yes	No	Yes or No	Yes or No	Yes or No	1
Yes	Yes	No	No	N/A	1
Yes	Yes	No	Yes or No	No	1
Yes	Yes	Yes	No	No	2
Yes	Yes	No	Yes	Yes	3
Yes	Yes	Yes	Yes or No	Yes	3
Yes	Yes	Yes	Yes	No	4

Learn

Documentation

Certifications

Events

Community

Support

Resources

Adobe Account

Adobe