Build "Table" panel

[none0nfg]

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.

[ivanahuckova]

@none0nfg you can use Organize fields transformation to hide all columns that are repeating and that you don’t want to see.

[none0nfg]

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:

[none0nfg]

I could not upload more than 2 images.

[ivanahuckova]

What version of Grafana are you using?

[none0nfg]

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.

[ivanahuckova]

I am glad you were able to solve it out!