Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a bar graph where sometimes if value of one bar is higher than other bar i find a grey space on the top of the bar graph. Which is something like this:
I used aggr formula here but then the issue i got is, the graph has non rounded value. Can i use something that after aggr formula, it rounds to nears 500 or thousand.
The formula i am using is
=max(aggr(count (distinct Column_measure),Dimension1,Dimension2)) * 1.75
Try like this
=round(max(aggr(count (distinct Column_measure),Dimension1,Dimension2)) * 1.75,100)
Do you need to the forced zero axis ? I mean to start the scale with 0 if you disable then according to the data it will get auto aligned
I need the force zero axis
Try like this
=round(max(aggr(count (distinct Column_measure),Dimension1,Dimension2)) * 1.75,100)
You are a star!
Thankyou - it works