Hello. I’ve got a problem.
Datasource is Prometheus
I’m trying to build the table panel with metrics from hosts. And i just don’t know how to merge many series by id, or hostname.
I found “Outer Join”, and yes values merging, but label names repeating 2 times like this:
Thx.
@none0nfg you can use Organize fields transformation to hide all columns that are repeating and that you don’t want to see.
I’ve tried it too, but this function is hiding 2 the same columns
Before Organize fields:
After hiding the Hostname column:
And also in the options of transformation only 1 name is presented:

I could not upload more than 2 images.
What version of Grafana are you using?
My version is Community Edition V7.1.1 In Docker
UPD: I’ve tried to use newer version. And in the latest version this problem solved, The repeating columns additionally got numbers. So, i think i should migrate to the latest version.
I am glad you were able to solve it out! 