Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
The "Dimension Limits" tab for bar chart has got options to limit the bars based on First, Largest, Smallest. Is there any way to add expressions in it and limit based on our expression.
Here I want to display 9 values based on some expression.
Thanks!!
I don´t think you can do this under Dimension Limits Tab. I would go for Calculated Dimension.
Well, the restriction above is based on the expression in your bar chart. So if you want to alter your dimension limits you can look at modifying your expression, either with set analysis, or with an if statement
e.g. if(Rank(your dimension limit expression,2)<10, bar chart expression)
In dimension limit, you can't write your expression. However the similar can be done in main expression itself(may be using set analysis) to achieve the same. Or, using calculated dimension.
Hi Martin,
Thanks a lot for the reply.
What does <10 indicate in the below expression you mentioned?
if(Rank(your dimension limit expression,2)<10, bar chart expression)
caculated dimension will work for sure.
Thanks!
The dimension limit expression will be validated and based on its (numeric) result, ranked. The <10 ensures that the bar chart expression will only calculated for Top9 results, .