I’m starting with Google Data Studio. So I have this
event_date (YYYYMMDD) and
event_timestamp (Unix Epoch in microseconds) columns for each record from BigQuery (original data source is Firebase). I created a time-series / bar chart (I tried both) that displays the x-axis as the hour of the current day (I filtered on
event_date) And the y-axis as the number of records.
The way I did this is to create a calculated field using the Data Studio function
HOUR(event_timestamp) and then displayed as
HH. The problem here is for certain hours that we don’t have any corresponding record, there is no entry for the x-axis. What I want is even if there are no records for that specific hour, it will still show. So basically, the x-axis numbers look like this:
00, 01, 02, ..., 22, 23
Side question: I noticed that the time series chart sorts from most recent to oldest. How can I reverse the sort?