topic Re: Combining timeseries, can this be done in DQL

Combining timeseries, can this be done

henk_stobbe — Wed, 04 Jun 2025 13:52:56 GMT

Hello,

What if you have to time series and you want to add/subtract them to create a new one......

Can this be done, or a I over asking?

KR Henk

Re: Combining timeseries, can this be done

Theodore_x86 — Wed, 04 Jun 2025 14:05:43 GMT

Hello.

Are you looking for something like the following?

https://docs.dynatrace.com/managed/discover-dynatrace/references/dynatrace-api/environment-api/metric-v2/metric-expressions

Re: Combining timeseries, can this be done

henk_stobbe — Wed, 04 Jun 2025 14:31:04 GMT

Hello Theodore,

Thanks for you answer, yes this is wat I like to see... But here comes then but (sorry) I want to see this in DQL so I can use the result in a Dashboard GenV3,

KR Henk

Re: Combining timeseries, can this be done

Theodore_x86 — Wed, 04 Jun 2025 14:42:00 GMT

Then you have to go with this I think:

https://docs.dynatrace.com/docs/shortlink/metrics-selector-conversion#arithmetic

Re: Combining timeseries, can this be done

krzysztof_hoja — Wed, 04 Jun 2025 19:59:58 GMT

The concept is called "iterative expressions"

There are few examples on DQL for Metrics page like this one: https://docs.dynatrace.com/docs/analyze-explore-automate/metrics/dql-examples#example-9-connection-failure-rate-by-host

e.g.

timeseries { new = sum(dt.process.network.sessions.new), {reset = sum(dt.process.network.sessions.reset), default:0}, {timeout = sum(dt.process.network.sessions.timeout), default:0} }, by:{dt.entity.host} | fieldsAdd result = 100 * (reset[] + timeout[]) / new[]

more details in dedicated section:

https://docs.dynatrace.com/docs/discover-dynatrace/references/dynatrace-query-language/operators#iterative-expressions

Re: Combining timeseries, can this be done

henk_stobbe — Wed, 04 Jun 2025 21:34:23 GMT

Hi Krysztof,

You are absolutely right, thanks,

KR Henk