cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Group again after a split by DQL

elenaperez
Dynatrace Participant
Dynatrace Participant

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?

4 REPLIES 4

sinisa_zubic
Dynatrace Champion
Dynatrace Champion

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

Oh this looks fantastic!

elenaperez
Dynatrace Participant
Dynatrace Participant

Thank you! 🙂

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

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

Featured Posts