Bar Chart - Show Null Value with a dual() expression

Touix — Thu, 13 Jan 2022 13:11:06 GMT

Hello All,

I am quite annoyed with my bar chart.

I have a list of products sold with a discount or not.

example:

Product, Nb sell with discount, nb sell without discount, average amount of price of discount

Pen, 0,2,-

Glass,2,8,50

Mask ,1,0,10

I have a problem in my bar chart to show the Pen value. I have my product as dimension and my expression is

dual('Nb sell with discount :' & count([Nb sell with discount]), avg([amount of price of discount]) )

but because my average amount for pen is null, it is not showed in my graph.

My question is how to show Pen with a label Nb sell with discount : 0 even my expression avg([amount of price of discount]) is null ?

Thank you so so much for your help,

Regards

Re: Bar Chart - Show Null Value with a dual() expression

Digvijay_Singh — Thu, 13 Jan 2022 13:25:17 GMT

May be try alt(avg([amount of price of discount]),0) to have value 0 in case expression results into null.