Duplicate Rows in Table

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

Hi,

Remove duplicates in Grafana is not supported. You can create a feature request issue at our Github repo. Contributions are always welcome.

Marcus