Dynamic dimension Top X

[#1]

Hi Community,

I have errors and related error types. I'm trying to show the error types of the top 5 errors in 5 bar charts.
Therefore I'm trying to do a dynamic dimension.

=if(aggr(rank(sum(Amount)), Error) = 1 , Type ) for all error types where error is rank 1

=if(aggr(rank(sum(Amount)), Error) = 2 , Type ) for all error types where error is rank 2

and so on.

But in this case I get only the top 1 error type. Can someone please help me with this forumla

thanks!!!

[Anonymous]

Hi,

take a look to the app aatached

[ashfaq_haseeb]

Check This,

Regards

ASHFAQ

[#4]

Try like this In expression --> Sum(Amount)

                    In Dimension limit

Instead of variable you can also use constant numbers