Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Field name is Existing Groups. Values are Yes or No. How do I write an expression to pull in a count of ONLY the "YES" values?
I would like to create a bar chart that lists a column for "yes" and a column for "no".
Count({<[Existing Groups]={'YES'}>} [Existing Groups])
Count({<[Existing Groups]={'YES'}>} [Existing Groups])
count(if([Existing Groups]='YES',[Existing Groups], if([Existing Groups]='NO',[Existing Groups] )) )
Thanks!