topic Re: Adding a filter in timeseries gives strange effect, is it a bug or is it a feature? in DQL

Adding a filter in timeseries gives strange effect, is it a bug or is it a feature?

henk_stobbe — Thu, 05 Jun 2025 06:22:34 GMT

Good morning,

Look at below example:

timeseries {
new = sum(dt.process.network.sessions.new),
{reset = sum(dt.process.network.sessions.reset), filter: dt.entity.host=="HOST-XYX"},
{timeout = sum(dt.process.network.sessions.timeout), default:0}
},
by:{dt.entity.host}

==> the filter gets places on new reset and timeout

In this example:

==> the filters are "and" so you get no results

So is DQL right or wrong?

KR Henk

Re: Adding a filter in timeseries gives strange effect, is it a bug or is it a feature?

GerardJ — Fri, 06 Jun 2025 06:07:32 GMT

Hi @henk_stobbe
This could be caused by the default union parameter value when combining multiple timeseries :

DQL Metric commands — Dynatrace Docs

Re: Adding a filter in timeseries gives strange effect, is it a bug or is it a feature?

krzysztof_hoja — Thu, 05 Jun 2025 18:58:50 GMT

The correct syntax looks like this and every thing works even if there is no common subset between data for 2 timeseries. Please use filter: clause inside regular brackets (not curly).

re: second query. Syntax is incorrect. This query should not even execute:

Re: Adding a filter in timeseries gives strange effect, is it a bug or is it a feature?

henk_stobbe — Thu, 05 Jun 2025 21:20:22 GMT

Hello,

This is why I like the community so much (-;

As a remark, you really need to drop the BY:

An you can now use things like:

| fieldsAdd x = arrayAvg(r1) - arrayAvg(r2)
| fieldsKeep x

This is what my customer liked to see. Thanks!

KR Henk

Re: Adding a filter in timeseries gives strange effect, is it a bug or is it a feature?

henk_stobbe — Fri, 06 Jun 2025 08:06:19 GMT

one more addon, if you want to keep timeseries:

| fieldsAdd x = timeout[] + new[]
| fieldsKeep timeframe,interval,x

Have fun!