CODEWITHSUNDEEP
looker-studio
ukraineinthemembrane
ukraineinthemembrane

Reputation: 11

Calculating Average Weekly Traffic in Data Studio

I've got a table in Google Data Studio showing monthly traffic numbers and I would like to have another table that shows average weekly traffic based on the monthly numbers in another table on the same page.

Having some trouble figuring out the custom calculated field formula for this. Any help would be appreciated.

Upvotes: 1

Views: 4005

Answers (3)

Priya Patel
Priya Patel

Reputation: 31

This seems to work for me.

SUM(Sales)/COUNT_DISTINCT((EXTRACT(ISOWEEK from DATE)))

Upvotes: 1

Parth Thakkar
Parth Thakkar

Reputation: 11

Depending on how you want to present this, there's a pretty easy, and decent solution - Reference Lines.

Using a reference line, you can chart weekly values (ie: weekly sessions) on a bar chart, then via a reference line, you can plot 1 line for the average of that period (all the bars currently present). Because it is native to the visualization it will recalculate as you you filter!

Example of a Reference Line in Action!

Upvotes: 0

Bobbylank
Bobbylank

Reputation: 1946

From your example, is it not as easy as your monthly traffic numbers / 4.34?

Upvotes: 0

Related Questions