topic DQL - timeseries resolution in DQL

DQL - timeseries resolution

christian_barth — Tue, 02 May 2023 13:49:44 GMT

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!

Re: DQL - timeseries resolution

imsingh — Wed, 19 Apr 2023 09:01:41 GMT

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

Re: DQL - timeseries resolution

manisundaram — Wed, 11 Dec 2024 11:46:55 GMT

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 ?

Re: DQL - timeseries resolution

imsingh — Wed, 11 Dec 2024 13:59:01 GMT

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/metric-commands#timeseries