Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I think i have a wierd problem! When i use Bar chart you can see that the Yellow does not have values for Feb -> Jul and that is right. But in the Line chart the yellow line does have values over these month which is incorrect.
Thanksfull for help!
Try unchecking continuous in axis tab.
-Sundar
Hi Erik,
that's just because, in a line chart, the data_points get connected automatically - a line is actually nothing else than dots (over the dimension_points) which are automatically connected.
=> A solution might be to somehow modify your formula so that, when there is no value, a 0 gets populated - that way, the line would plunge to 0 after Jan and go back up only in August.
HTH
Best regards,
DataNibbler
It is already unchecked.
I see, do you have any solution? I want exactly what you are explaining, that the line dips down to zero when there is no value!
in presentatioon uncheck "suppress zero value"
hope it helps
fill in the missing data points with zero value..
Im getting the information from a OBDC SQL server, so i dont see how i can do that
Nope 😕
Btw. you can show additional dots on the line to marke the data points..