Forum Discussion
Grouping
Hey I have a column called Age. I want to seperate it as groups like Age 55+ Age 45-55 Age 35-45 How can this be done?
- Hi - Create a calculated column such as
Age Group = SWITCH(True(), [Column Name] <=45, "35-45",
[Column Name] <=55,"45-55","+55")
This is assuming that there are no ages below 35 in have data.
D
Hi Anonymous
The above solution by davehus will work for you.
Just for your information - You can right click your age column and select "New Group" and then you can create grouping there. This is best suitable if you want to group some category, as in your case there is no gurantee that you will have all ages in your data.
Thanks
Raj
Thank You. But I want the legend to be shown as '45-55', '35-45' etc. Doing Groups just shows Age(bins) as 30, 35 etc given the size of the bin chosen. IS there any other way
- The Switch function I provided you with will work.
Thank You!