Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There,
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?
thanks
or even better to do it in the script and create a new Field named (e.g.) Category:
LOAD
Field1,
if(Field1<10000,'Category A',
if(Field1<=50000,'Category B',
if(Field1>50000,'Category C'))) as Category
FROM ...
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:
LOAD
Field1,
if(Field1<10000,'Category A',
if(Field1<=50000,'Category B',
if(Field1>50000,'Category C'))) as Category
FROM ...
Rob,
Agreed with Daniel suggestion , also have a look on link below:
assign variable to categorise values from data tables
Thanks,
AS
Thanks for all your help, I've got it working and looking great!