How to make a conditional calculation

Question

Summary

Content

Hi all,

I'm trying to figure out how to make a conditional count.

I have a column where the cells are filled whit "YES" or "NO" and I want to count how many "YES" I have in the whole column.

Thank you in advance for your help.

Juliandelgadillo · Answer

I'm sharing the one that finally worked after a lot of attempts.

Juliandelgadillo · Answer

I have done what you suggest like this:

However it is not counting only the 'Yes' this calculation is counting all registers.

jepva · Answer

Create a new column with a CASE WHEN statement.

Example:

CASE WHEN column1 = 'Yes' THEN 1 ELSE 0 END

Then make the default aggregation on that field a sum or count