Aggr() function

[#1]

Hi

Can anyone explain me how the Aggr() function works with beautiful example with data in different scenarios.

B'coz i'm getting confuse on this functionality. I've gone through the reference manual also..

[Anonymous]

Hello all,

I have a question related to Aggr function.

I actually have a chart where I display the top3 accounts depending on a number  |Basically number of calls they place], the problem is the top3 accounts are displayed as IDs , and I have a table where I have the corresponding names;

How can I replace the IDs by the corresponding account names in my charts?

So basically, if I take this example

Account Id, Number of calls

ID1, 10

ID2, 5

ID3, 20

ID4; 60

ID5, 7

Basically my chow ID4, ID3, ID1

I have another table where

Account Id, Account Name

So how to get the account names in the charts instead of the Ids

I hope that was clear

Thanks a lot,

[Anonymous]

Thanks!

[apthansh]

Hi -  I am trying to create a filter bucket with the below if statement but not sure what is wrong here..

Filter

Needs Improvement

Mid Range

Optimal

aggr(if(avg(OVERALLScore) <=12,'Needs Improvemnet',

       If(Avg(OVERALLScore) >12  and Avg(OVERALLScore)<=18,'Mid Range',

        If(Avg(OVERALLScore) >18  ,'Optimal')))ID) as Filter

In Bar chart I have ID as Filter and Avg(OVERALLScore)  as Measure and it works fine but Not the above IF..Can you help please ?

[khasimvali85]

Hello,

Use the below script to get the solution.

Script Level & UI Leval

Thanks,

Khasim.