Sort by metric
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 鈥淢etrics Sort鈥 option will reorder rows in a Data Warehouse report.
There are four possible ways that Data Warehouse reports may be organized with 鈥淢etrics Sort鈥, based on how date granularity, reporting dimensions, or metrics are configured, and whether 鈥淢ax rows鈥 is set:
- Layout 1: Line items are sorted in dictionary order (default). If 鈥淢ax 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 鈥渕ax 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 鈥淩eport layout鈥 column in this table to determine how 鈥淢etrics 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
recommendation-more-help
6b7d49d5-f5fe-4b7f-91ae-5b0745755ed2