Build "Table" panel

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:

image

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.

1 Like

I am glad you were able to solve it out! :slight_smile:

1 Like