Group metrics by server

[potchin]

I am pulling a wildcard list of HTTP response codes for a group of web servers. Eg..

webserver1: http200: 10 http404: 1 webserver2: http200: 13 http404: 2 http304: 5

At the moment there is no way to combine the metrics across webservers and show total number of httpXXXs since the http codes are being selected by a wildcard.

[potchin]

Any progress with this? 😃

[alexanderzobnin]

Sorry, haven't a time for this feature.

[julianoromani]

Hi @alexanderzobnin, there is a progress with this issue?

[divanikus]

Hello. This feature is very important in some scenarios. I have to create separate panels for each such group, when I can see everything on one graph using graphite backend. It would be cool to be able to group by any part of the query, i mean by host, by group, by application, by item.

[mave007]

I WAS having a similar issue when using the "table" visualization.

Querying for "host" and "Model" (zabbix key: system.hw.model) on query A and then "host" and with "OS version" (zabbix key: system.sw.version) but when I got the data, I had both columns separated, like this:

host	item	key	last value
host A	Operating System	system.hw.model	{model-of-host-A}
host B	Operating System	system.hw.model	{model-of-host-B}
host C	Operating System	system.hw.model	{model-of-host-C}
host A	Hardware model name	system.sw.os	{version-of-host-A}
host B	Hardware model name	system.sw.os	{version-of-host-A}
host C	Hardware model name	system.sw.os	{version-of-host-A}

So the fix for me was:

Right next to the Query, I went to Transform, then selected Group by and on Host -> group by and then on "Last value" I added Calculate and then First and Last

That left me with the following:

host	model	version
host A	{model-of-host-A}	{version-of-host-A}
host B	{model-of-host-B}	{version-of-host-B}
host C	{model-of-host-C}	{version-of-host-C}

[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!