Where clause in expressions

[#1]

I want to create a chart that shows the count and sum of one field but limits the output to criteria from another field. What is the correct syntax for the expression (eg: where field1 = X).  Thanks in advance

[rustyfishbones · Accepted solution]

Hi Michael,

See the attached file.Does it help

[agilos_mla]

Are you sure that Field2 is 1 (as integer) if not I'd suggest this:

sum({<Field2={">0 <2"}>} Field1)

or

sum({<Field2={'1*'}>} Field1)

[#4]

Thanks. This worked and helped me better understand.

[#5]

Hi Michael, Please try like below:

count({<Field2={1}>} Field1)

sum({<Field2={1}>} Field1)

[#6]

Thank you. This will work as well and helps me understand what I am trying to represent.