Data Studio
5.6K members online now
5.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.