Dividing between two values in a table

Hello,

I have a table with two columns (with data pulled from Google Analytics): event action and total events. 

3aac64c2-75b9-494a-9144-fa14ec51c560.png

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!

0 1 2,125
1 REPLY 1

Shru
Participant III

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.

Top Labels in this Space
Top Solution Authors