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

Display weekly data on the horizontal axis for chart instead daily

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

 Is it possible to use weekly interval on the horizontal axis for  e.g. line chart instead daily? 

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Kirill V
May 2017

Display weekly data on the horizontal axis for chart instead daily

[ Edited ]
Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

  Thank you, but i mean that we need this data summarized at the weekly level. There should be a column for every 7 days. Like shown on attached screen below (e.g. time period from 1 February to 14 February): https://drive.google.com/file/d/0BxlJphQEIHquMmZreDNZdEFMaFE/view?usp=sharing. We use as data source PostgreSQL. 

  We solved this issue, used format ISO Year Week (YYYYww).

 

 

View solution in original post

Display weekly data on the horizontal axis for chart instead daily

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

depends about you data source. 

If GA, select better the dimension "Day" in "Duration"

If not GA, edit your data source in Data Studio and dupplicate your field "Date"

Give the name "Day" and set the type "D" (Day of week)

 

After, in your chart, replace your field "Weekly" by "day".

Marked as Best Answer.
Solution
Accepted by topic author Kirill V
May 2017

Display weekly data on the horizontal axis for chart instead daily

[ Edited ]
Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

  Thank you, but i mean that we need this data summarized at the weekly level. There should be a column for every 7 days. Like shown on attached screen below (e.g. time period from 1 February to 14 February): https://drive.google.com/file/d/0BxlJphQEIHquMmZreDNZdEFMaFE/view?usp=sharing. We use as data source PostgreSQL. 

  We solved this issue, used format ISO Year Week (YYYYww).