Hello,
I have a table with two columns (with data pulled from Google Analytics): event action and total events.
I’d like to divide the total events in the submit row by the total events in the pageview row to calculate submit rate automatically (so, 19,796 / 663,177). Have been stuck on this, would appreciate your help. Thanks!
Check if this helps
Create one custom measure (Submit_Events) with filter value Event Action = submit.
Create another custom measure(Pageview_Events) with filter value Event Action = pageview.
Now the look will show 2 separate measure columns. Add a table calculation to divide both these measures > Submit_Events/Pageview_Events.