Put data in to Groups

[anuradhaa]

Hi,

i have a data set which have age 18-70 . i need to cataoried them in groups. 18-22,22-25 etc.

Then i want to use those data in charts.

Please tell me how can i catogoried those data in to groups.

Thanks

[sreenivas · Accepted solution]

if u want to do in the script side

if(Age>=18 and Age<22,'18-22',if(Age>=22 and Age<=25 ,'22-25','Above 25') as AgeCategory

or

Add this in Calculated Dimension

if(Age>=18 and Age<22,'18-22',if(Age>=22 and Age<=25 ,'22-25','Above 25')

[anuradhaa]

Thanks