AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

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

Page views per quarter

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi

I am trying to set up a bar graph comparing page views for the previous three quarters, so a graph with one bar for page views from January - March, one bar with page views from April - June, etc

 

Is that possible?

 

Libby

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Libby Y
July 2017

Re: Page views per quarter

Participant ✭ ✭ ☆
# 3
Participant ✭ ✭ ☆

Page views per quarter

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

What's your data source? If it's google analytics, go in and edit your data set to create a new "quarter" dimension based off of date. The formulas is quarter(date). Then, you can use quarter as your dimension and pageviews as your metric. 

Marked as Best Answer.
Solution
Accepted by topic author Libby Y
July 2017

Re: Page views per quarter

Participant ✭ ✭ ☆
# 3
Participant ✭ ✭ ☆

Quarter.PNG

Page views per quarter

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Hi,

 

I followed this example and it worked - thanks! However is there a way to show quarters over the course of 2 years? I have a combo chart where the X axis is quarters (as made above), but I want more than 4 quarters (so 2017 and first half of 2018). Changing the date range still leaves me with 4 quarters.

 

If possible i want to show Q1, Q2, Q3, Q4 of 2017 and Q1, Q2 of 2018

 

Thank you,

Darren