DQL - timeseries resolution

[christian_barth]

Hello.

Can someone help me add resolution (e.g. 1 minute) to this DQL query?

timeseries avg(dt.host.disk.used), by:{dt.entity.host}, from:now()-4h
| limit 5

Thanks in advance!

[imsingh · Accepted solution]

I think you are looking for the interval parameter:

timeseries avg(dt.host.disk.used), by:{dt.entity.host}, from:now()-4h, interval:1m
| limit 5

[manisundaram]

Eventhough I set interval to 1m, when I am looking at 7 days of data it is not respecting that.

Say for example, I set the interval to 5 mins. It respects that when running for data from last 24 hours. But if I run it for last 7 days resolution changes to 10 minutes and last 30 days it changes to 30 minutes. How can I force the resolution to be 5 minutes even though I look at 30 days of data. That is one of the features expected to be in Grail correct ?

[imsingh]

Hi there

AFAIK, what you're asking isn't possible. The behavior you're describing is the expected behavior. For more information, look at https://docs.dynatrace.com/docs/discover-dynatrace/references/dynatrace-query-language/commands/metr...