Show all dates in a chart

[#1]

Hi,

I want to show all dates in a chart even where its no sales.

This is what I have:

• Table 1 - Sales
  • DateID (YYYY-MM-DD)
  • SalesDate
  • NumOfSales
• Table 2 - Calendar
  • DateID (YYYY-MM-DD)
  • CalendarDate
  • Year
  • Month
  • Day

The Table 1 includes only the SalesDate with sales, otherwise the date won't exist. This tables is the associated with Table 2 with the date as key. The table CalendarDate is all dates that exists.

I my chart I'm using CalendarDate as dimension and the sum of NumOfSales as expression. But the chart will leave out CalendarDates with no sales. How can I show all CalendarDates during that period, even the dates with no sales?

Thanks ahead!

[jagan]

Hi,

In Presentation tab Uncheck the "Supress zero values" option.  Hope attached file helps you.

Regards,

Jagan.

[#3]

Hi,

It didn't work. I think I need to add more information to this question.

In the Table 1 there is also a SalesType indicating the type of the sales. For at chosen period (Year and Month from Table 2) and with a specific SalesType there is some SalesDates without any sales.

There is no difference when I'm unchecking the "Supress zero value".

When I place the field SalesDate on the sheet, I can see the missing dates but they are grey - no relation to the selection.

Is there another way to show the missing dates?

Thanks