Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I want my y axis range set to this set analysis in a bar chart
max([Mileage Range]) +10
I cant use auto because the total label in a first bar in bar chart is not visible
so When I filter the max value in a field and +10 should be added so that the total label in first bar will be visible.
HI
Your exp is count([VP report date]),
so in that case try like below
Max(Aggr( count([VP report date]), urchartdimension)) + 10
You can change the range here:
Hi Lreclever,
Thanks for your reply,
yes the max([Mileage Range]) is working but the +10 is not working please check it should work according to the selection in filter pane.
Hi LRuclever,
Actually Its not working I have a field called mileage range, so, the max value of the bar chart should calculate and add it with +10
Try using this:
Max(Aggr(<Your Chart Measure>, <Your Chart Dimension>)) + 10
No Lruclever,
Still not working I am just getting max value but the +10 is not working if i filter something the range goes according to the max value in a bar chart.
Try this
RangeSum(max([Mileage Range]), 10)
Please share snapshot for better understanding.
This are the set analysis used in this bar chart
HI
Your exp is count([VP report date]),
so in that case try like below
Max(Aggr( count([VP report date]), urchartdimension)) + 10