Style options for dimensions of type: tier

(Nicole Beyer) #1

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 Likes