currently I am trying to calculate the KPI for the number that an activity is occuring overall.
I tried this formula:
COUNT(CASE WHEN “Activity_Table”.“Activity_Column” = ‘Selected_Activity’ THEN 1 ELSE 0 END)
Obviously it did not work. It gives me the result of all my activities/rows from the whole table.
I actually do not get why it does not work.
I am very grateful for help