Top N chart Help

[Anonymous]

Hi All,

I need to create a dynamic Top N performance chart. I am having Owner as a Dim and Count(Service) as Exp.

So my exp like below

if(aggr(rank(Count(Service)),Owner) <=v_Rank, Owner, null())

The Variable needs to get input from end user.Here I what I am missing

[Anonymous]

Hi,

Enrique, I forget mention that I am using Bar chart. Will it make impact?And I need to have as a Expression. Not in calculated Dim.

[alkesh_sharma · Accepted solution]

In a bar chart you can simply use dimension limit, no need to go for rank functions and select the expression on basis of which you want to create TOP values.

Regards,

Alkesh

[arulsettu]

have you tried by removing null

[ecolomer]

You can use the same expression on bar chart, also

[Anonymous]

Hi Alkesh,

I can do that. But the limit should be dynamic. User will give run time values

[arulsettu]

try like this

=if(aggr(rank(Count(Service),3)<=$(v_Rank)),Owner, null())

[Anonymous]

Yes, I missed that simple step...

[alkesh_sharma]

Yes you can do that, pass a variable in the limit tab, and give the user an input box.