I am using an event category that I am using to measure conversion on my site (a form completion) in GA. I want to create a Calc for conversion rate on this event. I'm not sure how to single out this particular event and divide it by total sessions (or users) in order to get this conversion rate.
If I do
Sum ([Total Events])/Sum([Sessions])
it will include all events for the whole site, not just the category I'm using to track conversions.
This has been running for some time and not been tracked as a Goal, therefore I can't use a Goal Completion Rate calculation.
Any help would be appreciated.
Have you found a solution to this question? If so, please share, otherwise, have you tried creating the specific segment you want on the the google analytics site then connecting to that segment through Tableau?