Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
My raw data looks like this:
Age | Gender | KPI |
---|---|---|
20 | F | 100 |
20 | M | 200 |
I would like to create new categories and have them show up in list boxes on the side, such as 'Females 20-30'. However, I also want 'Adults 20-30'. I'm unable to do this through if statements because Females 20-30 is a subset of Adults 20-30. In other words, there's data overlap between the two segments. Is there a way to get around this?
Thanks,
Yefan
There is no 30 age in ur sample data?
Yes, in my dataset there would be every variation of age and gender.
How would I be able to create a listbox of segments which sometimes overlap each other? Such as:
'Adults 20-30'
'Female 20-30'
'Female 20-25'
Thanks!