Question

Style options for dimensions of type: tier

  • 4 February 2015
  • 2 replies
  • 337 views


See the documentation about tier styles in our docs.



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


Default, 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


2 replies

Can we add label names to all the integer type style?

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)?

Reply