Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Only displaying data which reaches a certain % in bar chart

Hi,

I have a bar chart which has 3 dimensions and one expression which gives the value as a %

If the % value is below 5% I do not want to display it - does anyone know how to do this?

Thanks

2 Replies
Not applicable
Author

Use calculated dimension. Instead of

MyDimension

use

=if( your_expression > 0.05, MyDimension)

johnw
Champion III
Champion III

That may not work without a little modification. If the expression is sum(A)/sum(B), for instance, the sums won't work without doing an explicit aggregation. Adding aggregation across the three dimensions would be one solution, but since we have three dimensions, I'd think we'd be adding it to all three, which is an unweildy solution even if it would work. It would be simpler to apply this approach to the expression instead of the dimensions:

if(your_expression>0.05,your_expression)

And make sure that zero values are suppressed.