Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
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')
Thanks