Duplicate Rows in Table

Grafana Table Panel
1

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

2

Hi,

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

Marcus