Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Michael,
See the attached file.Does it help
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)
Thanks. This worked and helped me better understand.
Hi Michael, Please try like below:
count({<Field2={1}>} Field1)
sum({<Field2={1}>} Field1)
Thank you. This will work as well and helps me understand what I am trying to represent.