topic Timeseries arithmetic in DQL

Timeseries arithmetic

Rudolph_Sedlin — Fri, 09 Jan 2026 14:32:15 GMT

I am currently sending percentage-based approval rate metrics to Dynatrace and creating line-graph dashboards using timeseries like these:

timeseries APPROVAL_RATE=avg(SERVICE_APPROVAL_RATE_OVERALL), interval:1m

That being said, I am unsure how I show the decline rate (1 - Approvals) on those boards, as that requires arithmetic between timeseries presumably. The DQL seems poorly documented, but I would rather not alter my data model to send both approvals and declines.

Re: Timeseries arithmetic

jolinger — Fri, 09 Jan 2026 18:23:53 GMT

You can use an array operator to operate on every portion of an array:

timeseries APPROVAL_RATE=avg(SERVICE_APPROVAL_RATE_OVERALL), interval:1m
| fieldsAdd DECLINE=1-APPROVAL_RATE[]

Re: Timeseries arithmetic

Rudolph_Sedlin — Mon, 12 Jan 2026 13:09:45 GMT

Thank you so much, that did the trick! I can even evaluate the approval rate itself now via division of the approved events over the totals using this syntax, which simplifies my metrics model.