Re: Not able to sort correctly a top 10 in a bar chart
I understood the problem. when you use expression like this:
=IF(Sum(revenue) > 200,Sum(revenue))
that means when Sum(revenue) <= 200 the expression returns Null, so the chart does not know how to deal with it correctly. You can try to force the chart to ignore it by checking "Suppress when value is Null" but the chart will continue to see it as values that belong to Others, and you can not sort the chart in ascending manner correctly.
The solution i found was to use a Calculated Dimension where i use the condition:
=If( Aggr(sum(revenue), Customer)>200 ,Customer)
So It is forced that only the customers that have revenue above 200$ to be included in the dimension. Then I check "Suppress When Value Is Null".
In the Expresions Tab there is Sum(revenue).
and eventually in the Demension Limits Tab I choose "Show Only the Smallest 10 Values".