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
5.3K members online now
5.3K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

"Date Hour" Data Type does not play nicely with Date Range filter

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi, I have a Google Sheets data set of ~8760 rows and two columns. This is hourly data for a whole year (8,760 hours in a year). The hourly data displays fine in a Studio chart, but when I add a Date Range to the page, the filter does not work - it just continually displays all the data without filtering by date. However, if I use the "edit data source" window to change the Data Type from "Date Hour - YYYYMMDDHH" to simply "Date - YYYYMMDD" the Date Range filter works as expected (but of course I'm now displaying daily data, not hourly). If I then change the Date Type back to "Date Hour" it displays hourly data correctly! But...then when I select a new range of days in the Date Range, the chart goes back to displaying all the hourly data for the year and the filter stops working. Seems like a bug to me. Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Tripp H
November 2016

"Date Hour" Data Type does not play nicely with Date Range filter

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Ok, I head back from Google. The way to force this to work is "create a derived field and make it a date and you pick it as your date dimension and pick the original hourly data as the time dimension for your time series chart."

 

This worked for me.

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Tripp H
November 2016

"Date Hour" Data Type does not play nicely with Date Range filter

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Ok, I head back from Google. The way to force this to work is "create a derived field and make it a date and you pick it as your date dimension and pick the original hourly data as the time dimension for your time series chart."

 

This worked for me.