7 Replies Latest reply: Nov 24, 2014 5:00 AM by Joaqu�n L�zaro RSS

    Lost with missing values

    Joaqu�n L�zaro

      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