Table transpose with Zabbix data source

[Aegeus]

Hey guys, I’ve read some posts in the forum about this but still couldn’t find an answer so I figured I’d just ask.

I’m querying from Zabbix server v7.2 the bits sent and received on my routers (I have approximately 40 routers). At first I wanted to put in one table the bits sent, received and the total traffic per router however after hours of trying I came to the conclusion that there was just no way to do this.

Now what I’d like to do is simply query the bits sent in one table that contains 3 columns (Router ID, Bits sent, Time). Is it possible ?

I’ve tried the series to row transform but it didn’t give the wanted result.

For reference, here’s how the table is looking right now :

[Aegeus]

Can this poor man get an answer please.

[yesoreyeram]

Can you post screenshot of your queries and response data of possible?

[Aegeus]

Hey, of course, here they are.

The goal here is to have a table with the following columns :

| Router ID | Bits Sent | Bits Received | RSRP | RSRQ | SINR | ICMP |

From what I’ve tried so far, I don’t think it is possible but I’d love to hear your insights.