Line Chart - Show Null Values as Zero in a Month Dimension

[#1]

Hello,

I have a line chart like the following:

• X axis: Month dimension
• Y axis: Territory for every Month

Each line represents a specific Territory with a value for the months

The thing is that not all the months have a value. Some of them are null.

What I want is to show all months, whether they have a value or not, in the last case, I'd like to have a 0 for the value.

So that I'd see all the months and the corresponding value for every territory.

For that line chart I'm using:

• MONTH as a Dimension
• TERRITORY as a Dimension
• Expression

COUNT ({$<FLAG_Anomaly={"With Anomaly"}>} DISTINCT ACCT_ID_COUNT)

/

COUNT ({$<FLAG_ANOMALY={"With Anomaly","No Anomaly"}>} DISTINCT ACCT_ID_COUNT)

But there are some months like January and February where the value is null...

Do you know how could I do that, to turn the value I get from the expression to 0?

Thank you!

[Anonymous]

Try creating a Master Calendar to fill in the null dates:

Creating A Master Calendar

You can also avoid nulls in non date fields by using IF(LEN(TRIM( [Field Name] )) = 0,0,[Field Name])

[sujeetsingh]

Creating a master calender is the best way to deal with these presentations