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

MySQL and date range

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭
Hi,

No matter what I do the date range dimension is not passed to MySql query.
I set a date filter and set date range dimension on report settings and date range dimension on table component.

The query always queries the whole database:
SELECT TS, SUM(PAYMNT_AMOUNT) AS _PAYMNT_AMOUNT_ FROM analytics AS t0 GROUP BY TS

instead of

SELECT TS, SUM(PAYMNT_AMOUNT) AS _PAYMNT_AMOUNT_ FROM analytics AS t0 WHERE (ITEM_START_TIME >= '20170424' AND ITEM_START_TIME <= '20170523') ORDER BY _PAYMNT_AMOUNT_ ASC

Any ideas?

MySQL and date range

Follower ✭ ✭ ☆
# 2
Follower ✭ ✭ ☆

maybe it is related to the question i just asked? 

https://www.en.advertisercommunity.com/t5/Data-Studio/DataStudio-can-t-interpret-dates-properly/td-p...

it seems data studio cannot properly read some dates to set them as date dimensions.