Problem with Line Charts and Bar charts!

[#1]

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!

[sundarakumar]

Try unchecking continuous in axis tab.

-Sundar

[datanibbler]

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

[#4]

It is already unchecked.

[#5]

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!

[alexandros17]

in presentatioon uncheck "suppress zero value"

hope it helps

[rbecher]

fill in the missing data points with zero value..

[#8]

Im getting the information from a OBDC SQL server, so i dont see how i can do that

[#9]

Nope 😕

[rbecher]

Btw. you can show additional dots on the line to marke the data points..