Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table in a sheet with multiple measures
id | measure1 | measure2 | measure3 | measure4 |
1001 | 10 | 0 | 0 | 0 |
1002 | 9 | 0 | 1 | 0 |
1003 | 5 | 0 | 0 | 0 |
How would I get a count of rows that have 0s in measure2 measure 3 and measure4?
Not sure but you can try this
Count({<measure2={0}, measure3={0}, measure4={0}>} id)
Count(DISTINCT If(measure2=0 and measure3=0 and meaure4=0, id))
Or
Count(DISTINCT{<id={"=measure2=0 and measure3=0 and measure4=0"}>}id)