Table transpose with Zabbix data source

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 :

(post deleted by author)

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

(post deleted by author)