Solved
Formula Help
Hi Everyone, I need to create a formula for an indicator widget which will count all rows in a certain column that meets a condition divided by all rows in that column. For clarity, I want to count...
Hi DRay,
It was actually a much simpler solution than i thought. I just added a custom column that put a 1 or a 0 in depedning if the condition I was looking for was met using. And then summing that divided by the total number of rows.
CASE WHEN [{condition}] = '{condition met}' THEN 1 ELSE 0 END
and then
(sum([Column_name])/[# of rows])
