Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI everybody,
for example, i want to show the 5 smallest sales in a bar chart and when i use Smallest Dimensions Limits, the bar chart gives no data to display because many salesman have no sales !
Is it possible, in a bar char to have the 5 smallest values, which are different from zero.
Regards,
Johann
It works with as calculated dimension if(aggr(sum(MT_FACT),CODE_CLT)>0, CODE_CLT) and Suppress When Value Is Null checked. See attached example.
HI
You can use rank() function for that,
for ex:
in expression
if(rank(sum(Sales)) < 5, sum(Sales))
greater than zero,
u can use like this
=if(rank(sum({<Sales = {'>0'}>}Sales)) <=5, sum(Sales))
hope it helps
Watch! rank fuction = 1 is first, no last. 2 is the second, and so on. is there an inverse rank?
example kank(Vettel) = 1, rank(Alonso)=2, ......, rank(last), we don't know. How many are they?
If is a simple table, use dimension limits.
In the presentation tab check suppress cero values.
it seems that suprress 0 value with smallest in the dimensions limits doesn't work.
I will try to send an example
Hi
For inverse,
rank(-sum(Sales))
hope it helps
thank you for your answers.
as a conclusion, the smallest option in the dimension limits is diffocult to use without writing a specific expression. See qvw in attachement
Hi
PFA
thank you, i know this method in a straight table, but we can't do the same in the bar chart below !
Hi
PFA
Hope it helps
Thank you very much Mayil. It works indeed.
But i noticed you don't use Dimensions Limits