Months with zero values not being shown in the chart

[Anonymous]

I have used canonical calendar script given in the link pasted in this blog as suggested by Rob.

I need to show missing months in the SLA resolution achievement.

I am getting a graph such as the one pasted. It merely skips Dec where there are nil resolved tickets. It needs to touch zero for Dec 2016. I have unchecked Suppress Missing and Suppress Zero-Values in the Presentation tab.

I am using the expression as

count(DISTINCT{<SLA_INDICATOR={'SLA_MET'},DateType={'Resolved','Resolved_RTC','Resolved_Regulatory_Static_2016'},[Referred to CPS]={'Y'}>}[TR #]) 
/
count(DISTINCT{<SLA_INDICATOR={'SLA_MET','SLA_NOT_MET'},DateType={'Resolved','Resolved_RTC','Resolved_Regulatory_Static_2016'},[Referred to CPS]={'Y'}>}[TR #]) 

Please can you suggest a workaround that I can do for it or do i need to change the calendar script?

[vardhancse]

Hi,

Chart properties->Presentation:

Disable: Supress Zero-Values

[Anonymous]

As mentioned in my query i have already disabled it

[sunny_talwar]

May be try adding a Avg({1} 0) at the end and see if that helps

(Count(DISTINCT{<SLA_INDICATOR={'SLA_MET'},DateType={'Resolved','Resolved_RTC','Resolved_Regulatory_Static_2016'},[Referred to CPS]={'Y'}>}[TR #]) 
/
Count(DISTINCT{<SLA_INDICATOR={'SLA_MET','SLA_NOT_MET'},DateType={'Resolved','Resolved_RTC','Resolved_Regulatory_Static_2016'},[Referred to CPS]={'Y'}>}[TR #])) + Avg({1}0)

[Anonymous]

when i used the above expression it gave me

[sunny_talwar]

Is the images shrunk or did you take a partial screenshot this time? It might be easier if we can have a look at your app if you can possibly share it with us.