CASE formula to sum (counter) when a text field occurs
I'm trying to create a metric that will sum a counter field (origin) (which is prepopulated with a value of 1) every time a text field with the value "Hello" occurs.
So, something like:
CASE WHEN field_name = 'Yes' THEN SUM (origin) ELSE END
I don't need the "else" in this case.