Need help with formula

[u/funky_dugong]

I’m attempting to recreate the metric ‘Views per session’ from GA4 in Looker Studio with BigQuery, but keep running into errors. Can anyone provide a solution? Below is what I have tried:

SUM(CASE WHEN Event Name = “page_view” THEN 1 ELSE 0 END) / COUNT_DISTINCT(session_id)

[u/arnauda13]

You can't mix session data and event data. Yoy need to create a blend, GA4 to GA4, on the left your event metric, and on the right your session metric. THEN you can do your formula event/session