Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to show the Y axis range from the minimum value of my chart and its should be dynamic.
For Ex(minimum 57 or 56) the Y axis range should start from this.
thanks in advance.
Hi,
In the Y-axis settings, you can change the range setting from Auto to Custom.
Then you can use this expression for calculating the minimum value :
min(aggr(Sum(Sales),YearMonth))
* Please note you'll need to replace the names of the fields with your real ones.