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,