Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, In an online graph where I compare two years, the data available for the current year ends in august. But I don't want the line to dip like in this image.
I just want blue line stops in august.
How to do? I don't see the option to do This. Thanks for your help
A
hi,
Here is what I found as a solution to my problem
if([GR VTE (A)]=0,null,[GR VTE (A)])
Regards
The line seems to be dipping because you have set custom min/max range. Set the Y-axis scale range to auto.
You can find the range option under Appearance -> Y-axis -> Range.
Regards,
Aditya
Thank You,
i confirm that Y-axis scale is set on Auto.
Regards
Arnault
Hi @Aditya_Chitale ,
I think you have created Master Calendar, correct me if i'm wrong and you are using Master Calendar field in this.
Either U can use direct field coming from Table , if u dont have u can create one.
Attaching Screenshot for your reference.
You can also explore Include zero value option. If this can help.
Thanks,
Tanish
Hi,
Hi Tanish,
no Master Calendar in the app.
I checked that there is no data on 9/10/11/12 induced by linked tables
Include zero value set on NO
same chart works fine on QV
incomprehensible
Thank you for your help
Arnault
Include zero value
hi,
Here is what I found as a solution to my problem
if([GR VTE (A)]=0,null,[GR VTE (A)])
Regards