Get bar graph to display a value even if there is no entry in raw data?

NabScope — Fri, 06 May 2022 09:31:23 GMT

Hi all,

I have been trying to figure this out for sometime and finally decided it is time I asked the community.

I have a bar graph that I'm displaying:

Dimension1: Month

Dimension2: Type

Measure: -NORMINV((Count([ReturnedQTY])/Sum([ShippedQTY])), 0, 1)

Associated Month and Type in data manager.

Results I'm getting:

Only if "ReturnedQTY" of a "Type" is present for a particular "Month", it will display results as expected.

Results I wish to have:

If "ReturnedQTY" of a "Type" is not present in "Month" /data file, display 6.

Else just return the above calculation.

Essentially, each "Month" should display all "Type" A,B,C,D.

I have tried an IF statement but it doesn't work:

if(([ReturnedQTY]<1), 6, -NORMINV((Count([ReturnedQTY:])/Sum([ShippedQTY])), 0, 1))

Any thoughts/ideas?

Any help very much appreciated.

Re: Get bar graph to display a value even if there is no entry in raw data?

vinieme12 — Fri, 06 May 2022 10:56:51 GMT

try

-NORMINV(alt(Count([ReturnedQTY:])/Sum([ShippedQTY]),6))

NabScope — Mon, 09 May 2022 02:33:38 GMT

Hi @vinieme12 , I've tried but:

also, it seems that alt doesn't work with aggregation functions (count in my case).