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

[Frank_Hartmann]

what happens if you add a second expression e.g.

avg({1}1/1)

and set this expression to invisible?

[pradosh_thakur]

did you check show all values in the dimension ? You need to enable this .

[balabhaskarqlik]

May be use single quotes in wild search like:

=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])))

[kumarravi]

HI @Anonymous,

It can be the combination of the following:

• Show all values in dimension Tab

• Uncheck suppress zero value and check zero on bar