Usage
measure: field_name { … }
}
Hierarchymeasure |
AcceptsA Looker identifier to name the measure |
Definition
The measure
parameter declares a new measure (aggregation) and specifies a name for that measure.
There are several criteria for a measure’s name:
- It must be unique within any given view.
- It must consist of characters
a
throughz
(no capital letters),0
through9
, or_
. - It must start with a letter.
There are many types of measures, as discussed further on this documentation page.
Examples
Create measures named product_count
and total_value
in a view named products
:
Things to Know
In order to have measures (aggregations) come through joins, you must define primary keys in all of the views involved in the join.
You can do this by adding the primary_key
parameter to the primary key field definition in each view:
To correctly handle joined measures, Looker relies on you specifying a primary key where the values are completely unique, non-NULL values. If your data does not contain a primary key, consider whether the concatenation of several fields would result in a primary key of completely unique, non-NULL values. If your primary key is not unique or contains NULL values and your query includes data that reveal those issues, then Looker returns an error as described in this Community topic.