How to avoid '0' expression

[NavinReddy]

Dear Experts,

please find the below screen shot,not able to avoid the '0' from chart.

i just want to display only value=1,need to avoid zeros from the chart.

please suggest.Here is the expression im using

=count(aggr(if(Count(DISTINCT{<Month=,RAG_RATING_CD={'R'},MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}Metric)=1

and

Count(DISTINCT{<Month=,RAG_RATING_CD={'R'},MonthYear={"$(=Date($(vMonth)-30,'MMM YY'))"}>}Metric)<>1,

Count(DISTINCT{<Month=,RAG_RATING_CD={'R'},MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}Metric)), Metric))

Thanks,

Niranjan

[NavinReddy]

Hi Stefan,

Good Morning,

please help me to find on logic. not able to resolve the issue here is the path of issue

How to calculate consecutive months count

Many Thanks,

Niranjan