Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a line chart in the front end which is basically a progress chart. I am using this formula to in the Y-axis
sum(WeeklyProgress)
The problem is that the weekly progress sometimes exceeds 100% like it gives values like 100.04 and because of this the chart in the Y-axis goes up till 150%( as it is coming with a gap of 50) so to accommodate 100.04 it gives axis till 150.
I don't want that...I want the axis till 100 only so I have applied an if statement to it but it's still showing the same thing
if(sum(WeeklyProgress) > 100, 100, sum(WeeklyProgress))
Can anyone help me with this?
Thanks
have you tried limiting the range ?