Combining timeseries, can this be done

[henk_stobbe]

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

[Theodore_x86]

Hello.

Are you looking for something like the following?

https://docs.dynatrace.com/managed/discover-dynatrace/references/dynatrace-api/environment-api/metri...

BR

[henk_stobbe]

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

[Theodore_x86]

Then you have to go with this I think:

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

[krzysztof_hoja · Accepted solution]

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-f...

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#ite...

[henk_stobbe]

Hi Krysztof,

You are absolutely right, thanks,

KR Henk