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

Time Grouping

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hey, 

 

Is there any way for you to be able to group your data by period of time? For example, I have used SQL to round weekly data into each monday's date. I would like to compare this data week over week, but currently am getting a huge dip in data (due to the fact that the other 6 days have no data). I am hoping there is someway to group this data so that it can be displayed weekly. 

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Ben K
July

Time Grouping

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

If you go into Edit Connection and then into Fields, you can edit the 'Type' of data for each field. For your date field, you can change the 'Type' into weekly, monthly, or quarterly date groupings instead of daily.

View solution in original post

Time Grouping

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

What's your data source? Are you using GA? If so, you could use the dimension ISO week.

Time Grouping

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

I was just using google sheets.... would google analytics allow for a smoother transition? 

Marked as Best Answer.
Solution
Accepted by topic author Ben K
July

Time Grouping

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

If you go into Edit Connection and then into Fields, you can edit the 'Type' of data for each field. For your date field, you can change the 'Type' into weekly, monthly, or quarterly date groupings instead of daily.

Time Grouping

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Thank you! Exactly what I was looking for!