Having issues adding custom metric to GDS table
I created a custom metric to calculate event actions:
SUM(CASE WHEN REGEXP_MATCH(Event Action, "Enquiry Submit") THEN 1 ELSE 0 END)
and it seems reporting properly. However when I add it, all other standard metrics in the table go 0 (bounce rate, entrances) and pageviews show much higher numbers. When I remove this custom metrics from the table, all other metrics start displaying properly. I feel like I am missing something, since all I am asking is to display pageviews, entrances, bounce rate and total events with specific action.. Any ideas? Thank you.