Lost with missing values

[JoaquinLazaro]

Hello guys:

I have the attached an app with a Fact Table and a master calendar.

I have created an evolution chart based on the calendar date, and it works with data but what happens when I choose the WebSite de-DE ??

I can see the 16th day in the x-axys but I can't see the 0 value, this WebSite has not information for this day.

I need help. What should I do to see this missing 0 value for 16th ?

I've tried joinning this two tables with LEFT, RIGHT, INNER, OUTER, and NATURAL (only JOIN) but it doesn't work.

Thank you very much,

Joaquín

[JonnyPoole · Accepted solution]

The website has no data for this day so the join to the calendar table will not result in a date.

In this situation, you have to force the dimension to show 'all values' (below) and the missing values will show as zeroes (as  you have already correctly unselected 'suppress zero values' on presetnation  tab)

[MarcoWedel]

Hi,

another solution could be to add a term, that delivers (zero-)values at the missing dates:

But of course the "Show all values" check box is the better choice ...

hope this is of any interest nevertheless

regards

Marco

[ashfaq_haseeb]

Like this

Regards

ASHFAQ

[JoaquinLazaro]

Hi jpe

Check "Show all values" hasn't been enoughm the chart still the same.

But, thank for help

Joaquín

[JoaquinLazaro]

Hi Jonathan Poole

Sorry Jonathan, it works. I have just checked the option in a wrong version of the app

Thanks again.

Joaquín

[JoaquinLazaro]

Thanks also to MarcoWedel and ashfaq_haseeb

[JoaquinLazaro]

Hi guys:

I need a bit more help.

I've created this new post Lost with missing values. Part II

Thank you for your help.

Joaquín