I need to calculate the performance to a filed on my website.
I have these GA4 events: Total Users and Send Email
I would like to know the % of total users that send an email, so easily Send Email/Total Users
Since “Send Email” is a parameter to GA4 dimension Event Name, I try to do it: Calculate Event name/Total User and add filter “Event name - exactly match - Send Email” but with this formula looker takes in consideration only users that sent an email.
For example if I have 100 users and 10 users send 25 emails, I need to calculate 25/100 but looker calculate 25/10.
Can someone help me, please?! Thank you!