I'm using a Google Analytics property as a data source in Google Data Studio.

I have a table where each row is a section of the site (The table dimension is "Page path level 1").

I'd like each row of the table to have (among other things) the average monthly pageviews for the selected date range. That is, I want to know:

(The total number of pageviews in the selected period) / ([days in the selected period]/30.42)

That's all easily done in a computed field except "days in the selected period".

How can I do this?

1 Answer 1


Try creating a new field under metric with formula "Pageviews / Count(Date)"

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.