Hello, very good day forum,
I would like to know if there is any way to sort by a metric, since when I use the filter it only sorts me by name, but I would like to filter by the metric
measure: count_responses {
type: count
drill_fields: [detail_responses*]
}
Hi @jael_hedz,
Thank you for the question - You can sort data in the explore section by clicking on the title of the measure in the data section.
You can also be really specific about how fields are sorted by adding a order_by_field
parameter to a dimension or measure in LookML
The order_by_field
parameter lets you use the sort order from a dimension, dimension group, or measure on another field of the same type, rather than using the default sort order. Fields that are referenced by the order_by_field
parameter must match the field type of the parent field. A dimension cannot reference a field of type: measure
, and vice versa.