Data Studio: How to create time series from BigQuery (Firebase) custom query
I added a time series chart to my report with the data source as a Big Query custom query. The table is from Firebase:
user_dim.app_info.app_instance_id as instance_id,
COUNT(1) as cnt_incoming,
CURRENT_TIMESTAMP() as dtime
event_dim.name = "incoming_event_name"
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.