Hi there,
I have created a table panel to display builds from a Jenkins job. At the moment the table lists the same job multiple times. I managed to hide the columns I didn’t want to see (instance, timestamp) but now have many duplicate rows (one for each timestamp) rather than an aggregated result eg,
Build Branch Result Description Username
125 chore/appscan SUCCESS Started by Quick Quick
125 chore/appscan SUCCESS Started by Quick Quick
125 chore/appscan SUCCESS Started by Quick Quick
124 chore/appscan FAILURE Started by Quick Quick
124 chore/appscan FAILURE Started by Quick Quick
This is the prometheus metrics query I run to produce this:
avg (jenkins_job_last_build{project=“$project”,jobname=“$jobname”}) without(instance,job,project,jobname)
Is there a way to remove the duplicates in Grafana and just show one row for each build? Or is this question better directed to the Prometheus community?
Thanks for any advice,
Ed