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

Data Studio: How to create time series from BigQuery (Firebase) custom query

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I added a time series chart to my report with the data source as a Big Query custom query.  The table is from Firebase:

 

SELECT
    user_dim.app_info.app_instance_id as instance_id,
    COUNT(1) as cnt_incoming,
    CURRENT_TIMESTAMP() as dtime
FROM
   [my_package.app_events_20160927]
WHERE
   event_dim.name = "incoming_event_name"
GROUP BY
   instance_id
ORDER BY
   cnt_incoming desc

 

According to the docs:  https://support.google.com/360suite/datastudio/answer/6370296?hl=en&ref_topic=6370347#custom_query

 

Data Studio is supposed to automatically insert current date in place of the date in the FROM table.

 

That is not happening, I am only seeing data for the exact table specified in the FROM clause.