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
It looks like tiers displayed in a dashboard are ordered alphabetically. Is there any option that will cause tiers to sort numerically (aside from the happenstance in the example in which the lead digits are neatly ordered)?
Can we add label names to all the integer type style?
Can we have labels for Tiers?
Can we have labels for Tiers?
I second this. Would be handy to have labels for tiers.