Showing 0 values in bar chart

[Anonymous]

Hi Experts,

I have expression like following

count(DISTINCT{<ows_Modified={"<=$(=timestamp(Today()))>=$(=timestamp(MonthStart(Today(),-$(vShowInputMonths))))"},id={'VERSION_HISTORY'},SHP_CAISFilter-={''},SHP_Status= {"*Closed*"}>}(aggr(min(ows_Modified),id,ows_ModifiedHistory,SHP_CAISFilter,SHP_Status,[ows_Problem Ticket])))

from above expression I'm unable to show value 0 on bar chart. Can anyone help me to  in this ?

Thanks,

Pooja

[manoj217]

Try this:

=count(DISTINCT({<ows_Modified={"<=$(=timestamp(Today()))>=$(=timestamp(MonthStart(Today(),-$(vShowInputMonths))))"}
,id={'VERSION_HISTORY'}
,SHP_CAISFilter-={''}
,SHP_Status= {"*Closed*"}>}
(aggr(min(ows_Modified),id,ows_ModifiedHistory,SHP_CAISFilter,SHP_Status,[ows_Problem Ticket]))))

[Anonymous]

Hi Manoj,

Can I know that what new thing/change you have done in existing expression?

Thanks,

Pooja

[PrashantSangle]

Hi,

Uncheck supress Zero- values from bar chart property > Presentation.

Regards,

[Anonymous]

Hi Prshant,

That is done .

Thanks,

[pradosh_thakur]

check - dimension -> Show all values

check - presentation -> suppress zero values

regards

Pradosh

[PrashantSangle]

good.

Regards,

[Anonymous]

Hi Pradosh,

That is already done .

Thanks,

[Anonymous]

Hi Team,

Can anyone help in this, as I have mentioned that presentation-- supress Zero- values is allready done but still unable to show 0 value on bar chart.

Thanks,

[manoj217]

why r u using this $(=timestamp(Today()))>=$(=timestamp(MonthStart(Today(),-$(vShowInputMonths))))"}, condition