chart problem

[#1]

Hi,

     everyone, I met a problem below, I don't know why the result is in the chart,

Could anyone explain it to me?

[MK_QSL]

if(count({<flag={'1'}>}sales)=0,'exception','normal')

[awhitfield]

What are you actually trying to achieve here?

Andy

[Gysbert_Wassenaar · Accepted solution]

'Flag' is not the same field as 'flag'.

And null values will not be counted so you'll never see the value 'exception'

Perhaps this does what you want: if(count({<flag={'1'}>}sales) + sum(0)=0,'exception','normal')

[Anil_Babu_Samineni]

Do you mean this?

[sunny_talwar]

Another way to do if without using if

Pick(RangeSum(flag, 1),'normal','exception')

[sunny_talwar]

I think I turned it around.... should have been this:

Pick(RangeSum(flag, 1),'exception','normal')