Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to use the belwo IF stamnt as one of the dimension along with Name in a pivot chart.
=if((Max(TOTAL <Name> Aggr(SUM(Handled),Name,Date)))<600,'0-600',if((Max(TOTAL <Name> Aggr(SUM(Handled),Name,Date)))<800,'600-800',if((Max(TOTAL <Name> Aggr(SUM(Handled),Name,Date)))<1000,'800-1000',if((Max(TOTAL <Name> Aggr(SUM(Handled),Name,Date)))<1500,'1000-1500','1500>'))))
How do i do it.
It works as an expression in a Table and i want that as dimension.
Or is it possible to add it as Variable and then in to dimension
You may want to read my description of Aggr from the 31st of last month on this thread:
I am getting the Avg & MAx based on the aggr function same as your example in table.
But how do i bucket them and show it in Graph as dimension with count of Names under each bucket
Yes you are right there was a typo and it is working fine.
But instead of calls as it is grouping in predefined intervals is there a possibility of getting the bucket predifined as using IF condition in dimension
To do this you will need to use your original IF statement, and nest Aggrs
accordingly.
But I am unable to add the below Script in teh dimension of Grpah
if((Avg(TOTAL <Name> Aggr(SUM(Handled),Name,Date)))<400,'0-400',if((Avg(TOTAL <Name> Aggr(SUM(Handled),Name,Date)))<800,'400-800',if((Avg(TOTAL <Name> Aggr(SUM(Handled),Name,Date)))<1000,'800-1000',if((Avg(TOTAL <Name> Aggr(SUM(Handled),Name,Date)))<1500,'1000-1500','1500>'))))
It says Error in Calcualtion
Got It Thanks