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