Data Studio
3.5K members online now
3.5K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Sessions Moving Average?

Follower ✭ ☆ ☆
# 1
Follower ✭ ☆ ☆

I've created a few different moving day session average calculations on Google Sheets. It's a simple calculation and creates a nice visualization. How would I be able to create the same on Data Studio when linked directly into Google Analytics, not into the Google Sheets. The reason why I want to link to GA directly is to add a source or medium filter which the user can change dynamically. I'm guessing this would be some kind of field calculation but no idea of the syntax.

 

Sessions Moving Average?

Follower ✭ ☆ ☆
# 2
Follower ✭ ☆ ☆

Maybe something along the lines of: AVG sessions when date is between x and y? And then just create several of these to vary the timeframe.

 

Sessions Moving Average?

Follower ✭ ☆ ☆
# 3
Follower ✭ ☆ ☆

+1 - I would also like to learn how to calculate moving averages in Data Studio.

 

Thanks
Sam

 

Sessions Moving Average?

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

 +1 having moving averages would be super helpful

Sessions Moving Average?

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

+ 1 this would be helpful to me also

Sessions Moving Average?

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

+ 1 this would be helpful to me also

Sessions Moving Average?

Visitor ✭ ✭ ✭
# 7
Visitor ✭ ✭ ✭

+1! really need ability to create Moving Average

Sessions Moving Average?

Visitor ✭ ✭ ✭
# 8
Visitor ✭ ✭ ✭

+1 on a moving average option.

Sessions Moving Average?

Visitor ✭ ✭ ✭
# 9
Visitor ✭ ✭ ✭
 

Today, I need to do this with Google Sheets, would be grate having this inside GDS

Sessions Moving Average?

Visitor ✭ ✭ ✭
# 10
Visitor ✭ ✭ ✭

+1 i would also like a moving average option.

 

I have two "work-arounds":

1. Using the linear trendline to show the bigger picture when the data is messy.

2. Showing data per week / month instead of day.