Show multiple attributes per host into a single row in a table

[jedd]

Describe the solution you'd like

Short answer -- something like described in https://github.com/grafana/grafana/pull/10050 -- but while this is ostensibly for the Table Panel, it seems to only work with InfluxDB and Prometheus sources.

Long answer -- say we have a Windows Host providing %-Used and MB-Free for multiple file systems, C:, D;, E:. One of our team wants to be able to show these numbers in a table such:

Drive / File System | %-Used | MB-Free C: | 27% | 345 D: | 72% | 123

Describe alternatives you've considered Multiple tables - but these take up lots of real estate, and the content (rows) aren't guaranteed to align (in some edge cases).

[alexanderzobnin]

I think it's possible with table data format support.

[egorky]

Just adding my two cents here, you can do a table in that manner by using Boom Table (https://grafana.com/grafana/plugins/yesoreyeram-boomtable-panel), you can even insert Font Awesome icons if you like

For example, this is a panel of mine. I arranged the data into columns even though they were rows belonging to other ítems:

[Vinikober]

I'm doing the same thing, but for now I got this: i don't know how to put in the same row, all the values Hostname | CPU | Memory

Just adding my two cents here, you can do a table in that manner by using Boom Table (https://grafana.com/grafana/plugins/yesoreyeram-boomtable-panel), you can even insert Font Awesome icons if you like

For example, this is a panel of mine. I arranged the data into columns even though they were rows belonging to other ítems:

[egorky]

@Vinikober in order to do that, you need to set the delimiter. In your case is ":" Mine was "." Be sure to define the right pattern that will match the rightmost portion of the item.

[Dark-ZBX]

@Vinikober in order to do that, you need to set the delimiter. In your case is ":" Mine was "." Be sure to define the right pattern that will match the rightmost portion of the item.

@egorky , @Vinikober Can you share a screenshot / example of how to configure zabbix metrics and patterns? I want to show the hostname, Used space%, Available space and total space in a single table.

[Sean-Bradley]

Instead of extracting the data through the Zabbix/Grafana datasource plugin, and then trying to transforming data in the table panel, it may be easier to use a MySQL data source instead and connect directly to your Zabbix database. Do the transform in your SQL query.

See this basic example where I use a SQL inner join, a count aggregate and a column alias.

There is no need to use the Zabbix/Grafana plugin in this case where you want to see data from different tables in a single table. (unless there is absolutely no other choice)

I went straight to the Zabbix MySQL DB instead.

You probably already have the MySQL data source to your Zabbix database already setup if you used the 'Direct DB Connection' option in your Zabbix/Grafana datasource configuration

[alexanderzobnin]

Created an issue for the new Transformation in Grafana https://github.com/grafana/grafana/issues/29393

[danielsilvapereira]

Hello, I would like to present more than one value in the table using zabbix

[vanimesh]

I am also looking for similar feature. I tried using boom table but its very complex to do.

[github-actions[bot]]

This issue has been automatically marked as stale because it has not had activity in the last 2 years. It will be closed in 60 days if no further activity occurs. Please feel free to leave a comment if you believe the issue is still relevant. Thank you for your contributions!