Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I would like to categorize the revenue measure of the scatter graph to, 'below 500', 'between 500 to 999', 'between 1000 to 1499', 'above 1500'. however, the following expression doesn't work.
Aggr(Sum(if([Revenue]<=500, 'below 500',
If([Revenue]>=500 and [Revenue}<=999, 'between 500 to 999',
If([Revenue]>=1000 and [Revenue}<=1499, 'between 1000 to 1499',
If([Revenue]>=1500, 'above 1500', 'Others'))))))
Could any one find out what are the mistakes? Thanks!
hi first of all
when using aggr function you need to give a dimension to run the aggr on
Aggr(if(Sum([Revenue])<=500, 'below 500',
If(Sum([Revenue])>=500 and Sum([Revenue])<=999, 'between 500 to 999',
If(Sum([Revenue])>=1000 and Sum([Revenue])<=1499, 'between 1000 to 1499',
If(Sum([Revenue])>=1500, 'above 1500', 'Others')))),YOUR_DIMENSION)
hi first of all
when using aggr function you need to give a dimension to run the aggr on
Aggr(if(Sum([Revenue])<=500, 'below 500',
If(Sum([Revenue])>=500 and Sum([Revenue])<=999, 'between 500 to 999',
If(Sum([Revenue])>=1000 and Sum([Revenue])<=1499, 'between 1000 to 1499',
If(Sum([Revenue])>=1500, 'above 1500', 'Others')))),YOUR_DIMENSION)