Need Help Creating a Filtering Calculated Metric
I would like to create a calculated metric that returns the sum of all events of a certain type of event. We have multiple kind of events, for example 'Homepage - Most Played', 'Homepage - New' or 'Homepage - Recommended'. From what I've read the way to create a metric that returns the total events of 'Homepage - Most Played', is with the following forumla:
SUM (CASE WHEN REGEXP_MATCH(Event Action, 'Homepage - Most Played') THEN 1 ELSE 0 END)
However this formula returns 1 rather than the sum of all events labeled as 'Homepage - Most Played', which would be closer to multiple thousands. For its visualization options, I would preferably be able to do this in Data Studio.
Thanks in advance for your help.