Date/data does not appear on Y-axis for value of zero on Chart.

[#1]

Hello,

This is an issue encountered with a chart which does not display the null/missing values.

Problem:

As you can see in the chart, the date 10/14/2013 is not displayed on the chart. In fact we have zero value for this date. But the idea is to display the date and instead of zero we write something like “No data”.

In figure 2 and 3 you will find the properties of the chart:

What have been tried so far:

In  dimension:

The Show all values is checked. But still not good.

In Presentation tab:

The suppress missing check box is unchecked. Still not good.

Thanks,

Selseva

[tresesco]

Try unchecking 'Supress Zero-Values'. You have just unchecked 'Missing'.

[jagan]

Hi,

Is your table having the records for that day with zero values?  If there are no records for that day then create master calendar and use this date dimension.  And unselect suppression zero values in Presentation tab.

CalendarMaster:

LOAD

    Date(InvoiceDate) AS InvoiceDate,

    Year(InvoiceDate) AS Year,

    'Q' & Ceil(Month(InvoiceDate) / 3) AS Quarter,    

    Month(InvoiceDate) As Month,

    Day(InvoiceDate) As Day,

    Week(InvoiceDate) As Week;

Load Date(MinDate + IterNo() -1 ) AS InvoiceDate While (MinDate + IterNo() - 1) <= Num(MaxDate);

Load

    Min(InvoiceDate) AS MinDate,

    Max(InvoiceDate) AS MaxDate

RESIDENT Invoice;

Replace InvoiceDate field name and Invoice table name with yours.

Hope this helps you.

Regards,

Jagan.