Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pareto chart (see attachment) and would like to show only top 80%. See attachment - I need to show dimensions only until the yellow highlighted part which is the 80% limit. How do I accomplish that?
Hi, this can be done if you use an if before the expression to check the cummulative percentage:
If([ExpressionForCummulativePercentage]<=0.8, [ExpressionForLineOrBar])
may be you need to use this condition in both bar and line expression
If([ExpressionForCummulativePercentage]<=0.8, [ExpressionForLine])
If([ExpressionForCummulativePercentage]<=0.8, [ExpressionForBar])
Hi, this can be done if you use an if before the expression to check the cummulative percentage:
If([ExpressionForCummulativePercentage]<=0.8, [ExpressionForLineOrBar])
I tried this earlier but did not work, not sure what I did wrong. But it worked. Thank you.
may be you need to use this condition in both bar and line expression
If([ExpressionForCummulativePercentage]<=0.8, [ExpressionForLine])
If([ExpressionForCummulativePercentage]<=0.8, [ExpressionForBar])
Yes that is exactly what I did and it worked. Thank you for your response.