topic Re: Group again after a split by DQL in DQL

Group again after a split by DQL

elenaperez — Mon, 07 Aug 2023 10:28:26 GMT

Hello,

I would like to create a tile in the new dashboards with DQL that shows the avg cpu filtered by osVersion.

I did this:

timeseries cpu=avg(dt.host.cpu.usage), by:{dt.entity.host}
| lookup [fetch dt.entity.host], lookupField:id, sourceField:dt.entity.host, fields:{osVersion}
| filter contains(osVersion, "2008")

But now I don't want to see it splited by host, but like the initial timeseries. How can I achieve this?

Re: Group again after a split by DQL

sinisa_zubic — Tue, 08 Aug 2023 06:40:44 GMT

Hi @elenaperez

Currently, this is not possible. But once the in function is available, the query would look like this

timeseries avg(dt.host.cpu.idle), filter: dt.entity.host in [fetch dt.entity.host | filter contains(osVersion, "2008") | fields id]

Best,
Sini

Re: Group again after a split by DQL

Fin_Ubels — Wed, 09 Aug 2023 00:44:50 GMT

Oh this looks fantastic!

Re: Group again after a split by DQL

elenaperez — Thu, 10 Aug 2023 07:00:17 GMT

Thank you! 🙂

Is there a date for this in function to be available?

Re: Group again after a split by DQL

sinisa_zubic — Thu, 10 Aug 2023 07:23:20 GMT

It is planned to be available by the end of this quarter/beginning of next quarter,