I have some data which I want to group/divide by its value. I want to split the data into three categories: value <10k, value <50k and Value >50k. How would I do this in a pie chart as an example? Do I need to set variables?
This could be done either in the script or using ValueList Function at the UI end..
Better if you can provide sample data to work... Thanks
you could use a calculated dimension with
if(Field1<10000,'Category A', if(Field1<=50000,'Category B', if(Field1>50000,'Category C')))
or even better to do it in the script and create a new Field named (e.g.) Category:
if(Field1>50000,'Category C'))) as Category
Thanks for all your help, I've got it working and looking great!
Agreed with Daniel suggestion , also have a look on link below:
assign variable to categorise values from data tables
Retrieving data ...