DQL percentage in a graph of two arrays (error versus total)

revoke7889 — Wed, 30 Jul 2025 06:42:57 GMT

Hi community! Struggling with the following - is it possible to create a percentage calculation and show it in a Dynatrace dashboard visualization (timeseries graph)?

I have the following working DQL that includes two arrays: total and errors:

fetch logs | filter dt.system.bucket == "kpi" | filter matchesValue(applicationid, "XXX") | parse content, "JSON:json" // several filters... | expand errorCode = json[data][errorCode] | fieldsAdd isError = if(isNotNull(errorCode), 1, else: 0) | makeTimeseries {total = count(), errors = sum(isError)}, time:{timestamp}, interval:{24h} | fieldsAdd errorRate = if(total > 0, round(errors * 100.0 / total, decimals: 2), else: 0)

However the errorRate does not seem to work. Here is a snippet from the raw response:

{ "records": [ { "timeframe": { "start": "2025-07-23T00:00:00.000000000+02:00", "end": "2025-07-31T00:00:00.000000000+02:00" }, "interval": "86400000000000", "total": [ 73229, 98446, 88787, 89492, 95227, 87934, 85991, 21596 ], "errors": [ 4487, 6250, 5598, 5856, 6691, 6580, 5673, 1278 ], "errorRate": "0" } ], "types": [ { "indexRange": [ 0, 0 ], "mappings": { "timeframe": { "type": "timeframe" }, "interval": { "type": "duration" }, "total": { "type": "array", "types": [ { "indexRange": [ 0, 7 ], "mappings": { "element": { "type": "double" } } } ] }, "errors": { "type": "array", "types": [ { "indexRange": [ 0, 7 ], "mappings": { "element": { "type": "double" } } } ] }, "errorRate": { "type": "long" } } } ],

Do you know a way to make this work? Thanks.

Please note even when commenting out the last line, I can't get error and total to be visualized:

Re: DQL percentage in a graph of two arrays (error versus total)

krzysztof_hoja — Sun, 03 Aug 2025 20:09:45 GMT

Last line should look like:

| fieldsAdd errorRate = if(total[] > 0, round(errors[] * 100.0 / total[], decimals: 2), else: 0)

you can find more information on iterative expressions here: https://docs.dynatrace.com/docs/discover-dynatrace/references/dynatrace-query-language/operators#iterative-expressions

My result on slightly different data, but with 2 last lines kept:

Re: DQL percentage in a graph of two arrays (error versus total)

revoke7889 — Tue, 05 Aug 2025 07:30:30 GMT

Thanks, working!

topic DQL percentage in a graph of two arrays (error versus total) in DQL

DQL percentage in a graph of two arrays (error versus total)

Re: DQL percentage in a graph of two arrays (error versus total)

Re: DQL percentage in a graph of two arrays (error versus total)