The class function enables you to group numeric values into buckets that you can then use as a dimension in a chart.
Imagine you have the following data table:
Say you want to group these users into age buckets of 10 years. So 0 to 10, 11 to 20, 21 to 30 etc. Your first option is to do a nested if statement to achieve this, however if the group buckets are evenly spaced apart you can use the class() function to do this quickly. In the load script on the table you could add this:
class(Age, 10) as AgeGroup
Great! A common question that follows this is how can I format it in a nicer way? For example you may actually want ‘to’ rather than <=x <.
|Fred||5||0 <= x < 10|
|Steve||20||20 <= x < 30|
|Bob||32||30 <= x < 40|
|Ellie||55||50 <= x < 60|
I recommend do a simple replace to achieve this.
replace(class(Age ,10), ‘<= x <‘, ‘to’) as AgeGroupclean
There are also two extra parameters in the class function that you can to replace the value of just x. This is another way to achieve the same result. If you are looking for uneven grouping I would suggest checking out the Interval Match or use a nested if statement for small number of groups.
|Bob||32||30 to 40|
|Ellie||55||50 to 60|
|Fred||5||0 to 10|
|Steve||20||20 to 30|