topic Data visualisation in DQL in Dashboarding

Data visualisation in DQL

Maheedhar_T — Wed, 02 Oct 2024 11:48:54 GMT

Hi,
I have a DQL in which we get the linux patching status. If the server is patched in last two months based on the content I am adding green and if it is not I am adding red as colour field. I want to visualise this in a pie chart where it should show green and red percentage of total hosts and when I select green or red in the chart it should show the hosts which are green or red.

Re: Data visualisation in DQL

ChadTurner — Mon, 30 Dec 2024 20:45:31 GMT

Im not sure if you are able to split it like that, but as a work around you can create two tiles, one stating the count of hosts that have been patched based off the content, and the count of hosts missing the content.

Re: Data visualisation in DQL

kingstar17 — Fri, 03 Apr 2026 17:43:51 GMT

@Maheedhar_T - can you share the DQL query in which you get linux patching status? or any reference docs? It will be of great help. Thanks.