Add job ID as label to every metric

[dominikduennebacke]

I want to build two tables in Grafana and I am struggling to join the different job metrics to receive my required dataset. Would it be possible to export the job ID as label in every metric? By that I could join them easily. Also open to any other suggestion how to build these tables.

All jobs that are running and ran in the given range
Use case: Provides a quick overview over all jobs. Can be filtered by job to display patterns.

id	project	job_name	runner_description	source	stage	status	duration	timestamp
1000001	root/sub/project	job01	runner01	schedule	run	success	264	1736467200
1000002	root/sub/project	job02	runner01	schedule	run	failed	378	1736467200
1000003	root/sub/project	job01	runner02	schedule	run	success	260	1736553600
1000004	root/sub/project	job02	runner02	schedule	run	failed	392	1736553600
1000005	root/sub/project	job02	runner02	schedule	run	failed	245	1736640000
1000006	root/sub/project	job01	runner01	schedule	run	running	317	1736640000

Success count, failed count and average duration per job in the given range
Use case: Statistics to support debugging and deciding which jobs require focus.

project	job_name	status_success_count	status_failed_count	duration_avg
root/sub/project	job01	2	1	256
root/sub/project	job02	1	1	365