Style options for dimensions of type: tier

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 4 2,919
4 REPLIES 4

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. 

Top Labels in this Space
Top Solution Authors