Grafana v9.5.18
We have data about CI/CD pipelines stored inside a Tekton metric Tekton Docs in Prometheus, at this point we aren’t able to change that. What we would like to do is show this metric on a visualization to show (for example) in the last 6 hours, how many pipelines have succeeded or failed.
The closest we currently have in terms of a query is: sum(round(increase(tekton_pipelines_controller_pipelinerun_duration_seconds_count{status=“failed”, cluster=~“$cluster”, pipeline=~“pipeline”}[$__range]), 1)) or vector(0)
When I like at the Query Inspector I see data like this, this is the data for “today so far” (11am, currently) and looking at the actual pipelines, we had a failure at 09:47 :
“Time”,“metric_name_redacted”
2024-06-05 09:56:00,1
2024-06-05 09:56:30,1
2024-06-05 09:57:00,1
2024-06-05 09:57:30,1
2024-06-05 09:58:00,1
2024-06-05 09:58:30,1
2024-06-05 09:59:00,1
2024-06-05 09:59:30,1
2024-06-05 10:00:00,1
2024-06-05 10:00:30,1
2024-06-05 10:01:00,1
2024-06-05 10:01:30,1
2024-06-05 10:02:00,1
2024-06-05 10:02:30,1
2024-06-05 10:03:00,1
2024-06-05 10:03:30,1
2024-06-05 10:04:00,1
2024-06-05 10:04:30,1
2024-06-05 10:05:00,1
2024-06-05 10:05:30,1
2024-06-05 10:06:00,1
2024-06-05 10:06:30,1
2024-06-05 10:07:00,1
2024-06-05 10:07:30,1
2024-06-05 10:08:00,1
2024-06-05 10:08:30,1
2024-06-05 10:09:00,1
2024-06-05 10:09:30,1
2024-06-05 10:10:00,1
2024-06-05 10:10:30,1
2024-06-05 10:11:00,1
2024-06-05 10:11:30,1
2024-06-05 10:12:00,1
2024-06-05 10:12:30,1
2024-06-05 10:13:00,1
Is there an easy / better way of presenting the pipeline metrics so that we can easily see how many pipelines have succeeded or failed in a given time frame? I’ve looked at other metrics on that Tekton docs page but none of them seem to be any better.