topic How do I merge several events, transposing several fields? in Dashboards & Visualizations

How do I merge several events, transposing several fields?

atg2 — Tue, 29 Mar 2022 20:52:37 GMT

I am creating a dashboard which contains a query that returns application health events of this type:

What I want instead is for the table to look like:

Server	Application	App Health	Disk Health	LDAP Health	Redis Health
servername	appname	UP	UP	UP	DOWN

What would be the best way to accomplish this?

Thank you for any suggestions.

ITWhisperer — Tue, 29 Mar 2022 17:31:19 GMT

You need to concatenate the server and application, the use xyseries, then split them again

atg2 — Tue, 29 Mar 2022 18:46:52 GMT

Worked great. Thanks so much!