I’m trying to calculate the percentage of total page views (% of Total Views) for each page in my Looker Studio report using data from GA4. The available metrics are Views, Views per Session, and Views per User.
I’ve tried creating a calculated field with the formula:
Views / SUM(Views) * 100
However, I’m getting an 'Invalid formula' error. What is the best way to calculate % of Total Views directly in Looker Studio, or should I use a blended data source? If blending is required, how do I set that up properly to include total views across all pages?
LinkedIn
Twitter
