Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a situation, where i need to use range (0-5,5-10,etc) in Y axis of a Line chart.
As we are calculating growth so the values of Y-axis would be dynamic and accordingly the Y-axis should vary.
Below is the example of the same -
Please let me know if you have any solution for the same.
Regards,
Akshay
What I am confused about is the fact that does 0-5% represent a single number or a range? How can Jan data be within a range of 0-5%? or are you trying to ceil any percentage between 0-5% to be showed as 5%?
I don't think you can modify the Y-Axis labels, but you can group your values using the class function as below
Class([Growth],0.05)
Remove Y-axis labels and overlap with text boxes
Hi Sunny,
We are calculating growth as a single number but at the time of representation we want to show it in range.
For example -
If the growth is 1.2% then it should be shown as 0-5%,
if it is -1% then -(0-5%), if 5.6% the 5-10% and so on
Regards,
Akshay
So basically you are ceiling it because now 0-5% is a single point for the range, right?
I would do something like this:
Ceil(YourExpression, 0.05)
If this doesn't work, would you be able to provide a sample?
You can set Static Step on Axis Tab wih expression like
Max(Aggr(Growth,Month))/5
Regards,
Antonio
Hi Sunny,
Please find the attachment.
What is required in y-axis is 0-10%,10-20% and so on.