AI-generated Key Takeaways
-
OrderBys determine the sorting of rows in responses, such as by access count or country.
-
You can order by metrics (like values) or dimensions (like country or date).
-
Ordering can be ascending (default) or descending, controlled by the
desc
boolean. -
Dimension ordering further offers alphanumeric, case-insensitive alphanumeric, and numeric options for string values.
Order bys define how rows will be sorted in the response. For example, ordering rows by descending access count is one ordering, and ordering rows by the country string is a different ordering.
JSON representation |
---|
{ "desc": boolean, // Union field |
Fields | |
---|---|
desc |
If true, sorts by descending order. If false or unspecified, sorts in ascending order. |
Union field one_order_by . Specify one type of order by for OrderBy . one_order_by can be only one of the following: |
|
metric |
Sorts results by a metric's values. |
dimension |
Sorts results by a dimension's values. |
MetricOrderBy
Sorts by metric values.
JSON representation |
---|
{ "metricName": string } |
Fields | |
---|---|
metricName |
A metric name in the request to order by. |
DimensionOrderBy
Sorts by dimension values.
JSON representation |
---|
{
"dimensionName": string,
"orderType": enum ( |
Fields | |
---|---|
dimensionName |
A dimension name in the request to order by. |
orderType |
Controls the rule for dimension value ordering. |
OrderType
Rule to order the string dimension values by.
Enums | |
---|---|
ORDER_TYPE_UNSPECIFIED |
Unspecified. |
ALPHANUMERIC |
Alphanumeric sort by Unicode code point. For example, "2" < "A" < "X" < "b" < "z". |
CASE_INSENSITIVE_ALPHANUMERIC |
Case insensitive alphanumeric sort by lower case Unicode code point. For example, "2" < "A" < "b" < "X" < "z". |
NUMERIC |
Dimension values are converted to numbers before sorting. For example in NUMERIC sort, "25" < "100", and in ALPHANUMERIC sort, "100" < "25". Non-numeric dimension values all have equal ordering value below all numeric values. |