Group again after a split by DQL

[elenaperez]

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?

[sinisa_zubic · Accepted solution]

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

[Fin_Ubels]

Oh this looks fantastic!

[elenaperez]

Thank you! 🙂

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

[sinisa_zubic · Accepted solution]

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