I am using Grafana v10.4.1. I use the PostgreSQL datasource.
I am using it to connect to our build system’s database (buildbot).
This contains information about build results.
I am using a query like this
SELECT
builders.name as builder_name,
TO_TIMESTAMP(builds.complete_at) as complete_time,
builds.results
FROM
builds
INNER JOIN builders ON builds.builderid = builders.id
I then transform it into a multi-frame time series and visualize it as a state timeline.
This is what it looks like. I know the message is because the complete_at is outside the grafana dashboard time range. However I want to also see build’s last state that are outside this time range so this is intentional.
What would be the solution here?