Percentage of events per page

[Nikita_SW]

Good afternoon,

I am looking to find a percentage of sessions that include an event but all guides I seem to find only offer a percent of total events. Let me explain in a little more detail:

I have a group of specific events, which are all named including the text "Main"

I would like to know how many sessions on our homepage, let's call that "Home" , carry out one of those events.

I assumed (I'm quite new to Looker so excuse my naivity) that I could calculate a field along the lines of: When [Full Page URL],"Home" then [Event Count] / [Sessions]

and then filter my events to "Main" events.

I have tried many variations of this but it still doesn't seem to be working. 

Any advice?

Thank you

[ArkadyZagdan · Accepted solution]

@Nikita_SW 

What we usually do in those cases inn Bigglo is connect GA 4 data with BigQuery where we can create such a sophisticated calculations using SQL and then push metrics into the Looker Studio.

I do not believe you can achieve this directly using a native LS connector.

[Nikita_SW]

Thank you very much for the clarification.

I had a feeling that might be the case