As of Looker 3.14 we has added several style options to the tier parameter.
The default behavior is style: classic
Our new options for the style
parameter are:
integer
interval
relational
style: classic
If you leave off the style parameter entirely then Looker will use the default behavior, style: classic
to give you the following result
- dimension: age_tier
type: tier
sql: ${age}
tiers: [0,10,20,30,40,50,60,70,80]
style: integer
integer
is for best for discrete values, like age.
- dimension: age_tier
type: tier
sql: ${age}
tiers: [0,10,20,30,40,50,60,70,80]
style: integer
style: interval
interval
is one of the most formal styles, very specific but can be unclear to some.
- dimension: age_tier
type: tier
sql: ${age}
tiers: [0,10,20,30,40,50,60,70,80]
style: interval
style: relational
relational
has the advantage that you can use the tiers as custom numeric expressions in filters.
- dimension: age_tier
type: tier
sql: ${age}
tiers: [0,10,20,30,40,50,60,70,80]
style: relational