Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm trying to remove a bar from a barchart. I'm able to remove it visually by adding this in my expression:
sum({< [BAR_TO_REMOVE]=-{''} >}[sales]) / sum(TOTAL [sales])
But it still takes 'space' on my barchart.
Any ideas?
Hi Lisa,
This is due to your Total in the second part. You could try 2 things:
1. Suppress zero values in your settings tab and null values in your dimension
2. sum({< [BAR_TO_REMOVE]=-{''} >}[sales]) / sum(TOTAL {< [BAR_TO_REMOVE]=-{''} >} [sales])
Jordy
Climber
Thanks. Unfortunately, these solutions don't work given they end up providing a different measure. For example, (2) leads to a fraction of the sales over a subset of sales, not entire sales.
Any other ideas?
Hi Lisa,
What about filtering it out of your data model? That would be the easiest solution.
Jordy
Climber
Would be the easiest, but I still need these values for other graphs.