Conditional statement in Dimension

[#1]

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

[stevedark]

You may want to read my description of Aggr from the 31st of last month on this thread:

Aggr function on avg

[#3]

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

[#4]

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

[stevedark]

To do this you will need to use your original IF statement, and nest Aggrs

accordingly.

[#6]

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

[#7]

Got It Thanks