Explore this snippet with some demo data here.
Timeseries charts show how individual metric(s) change over time. They have lines along the y-axis and dates along the x-axis.
You just need a simple GROUP BY to get all the elements you need for a timeseries chart:
SELECT AGG_FN(<COLUMN>) as metric, <DATETIME_COLUMN> as datetime FROM <PROJECT.SCHEMA.TABLE> GROUP BY datetime
AGG_FNis an aggregation function like
COLUMNis the column you want to aggregate to get your metric. Make sure this is a numeric column.
DATETIME_COLUMNis the group you want to show on the x-axis. Make sure this is a date, datetime, timestamp, or time column (not a number)
In this example with some Spotify data, we’ll look at the total daily streams over time: