line chart with missing data point

[#1]

Hi!

If you look at the attached file, you will see the line chart.

please take a closer look at the line that is running across relatively horizontally across the chart. the apricot color.

the thing about this line is that it has only three data points

two at the beginning of all dates and one at the very last date on the chart.

what this causes is even though the mid date range does not have any data for the apricot line, because it has data points at the beginning and at the end, the line goes across the chart. I want the line to go down to zero when the data point does not exist.

Please advise!!

Thank you in advance!

David

[#2]

I now understand what you are trying to do.

1. I still don't understand why Date(Floor(Date)) as Date, is not enough and we have to add Date as TimeStamp.

2. as I checked the structure of the data it gave me this and if you see the below screenshot, (I took out the real project name) it does not look like combination of all possible dates and project names has happened.

[sunny_talwar]

1) We don't need TimeStamp, I did not know if you were using it else where. If you are not, then get rid of it

2) All possible combination did not take place? Can you create a list box with Project Name and Date. Select a particular Project Name and see if any date is getting selected out? You can do the opposite check also. Select a date to see if any Project Name is getting selected out?

[#4]

Oh!! sorry sunny it did happen.

I double checked and the Date & Project combination has happened!!

so.... even though the combination is there.... with synthetic table...I think there won't be any value in other columns for the newly created Date  & Project combination... then we should probably try to make the null value into 0???

I don't understand how you were able chart out the sample data with 0 values...

[#5]

Oh!! sorry sunny it did happen.

I double checked and the Date & Project combination has happened!!

so.... even though the combination is there.... with synthetic table...I think there won't be any value in other columns for the newly created Date  & Project combination... then we should probably try to make the null value into 0???

I don't understand how you were able chart out the sample data with 0 values...

[sunny_talwar]

This is where you need to uncheck 'Suppress Zero Values'

When Checked

When unchecked

[#7]

Sunny!! it finally worked!!

from Presentation tab I marked off "Supress Zero-Values" and it worked!

I thought it wouldnt work since it is null not zero.

Thank you so much!!

could you explain why the supress zero is also affecting null values?

and one other question is

in dimension tab there is also "Suppress  when Value is Null" and clicking this did not make any changes..

what is the different between the two?

and if possible and related, I don't understand Show all Values that is right under Suppress When Value is Null...

Thank you so much Sunny!!!

[sunny_talwar]

1)I am not sure why Suppress Zero affect Null's, but for some reason they do (Sorry not very helpful there)

2) On the dimension tab, 'Suppress When Value Is Null' is for the nulls in dimension, where as 'Suppress Zero Value' on the presentation is related to expressions

3) Show all Value is basically used to show all values under a particular dimension. Again, I don't have a better explanation for this, but if you do a google search on these topics you might find a better explanation to these things then what I am providing you here.

I hope this helps.

Best,

Sunny

[#9]

Sunny, I really really really appreciate your help today, as always of course.

The TempTable that created the combination of date & project is so valuable.

Thank you so much!!!