topic Re: Calculate a succes rate line with metrics in DQL

Calculate a succes rate line with metrics

enrico_afkl — Mon, 11 May 2026 11:25:06 GMT

Hello,
I'd like to calculate a ratio between totalCalls and successCalls using a metric "log.prgoffer.foapi.baminfo.golden.exceptions".

timeseries totalCalls=sum(log.prgoffer.foapi.baminfo.golden.exceptions),
interval:
duration(toLong(substring($Interval,from:0,to:stringLength($Interval)-1)),
unit:getCharacter($Interval,stringLength($Interval)-1))

and

timeseries successCalls=sum(log.prgoffer.foapi.baminfo.golden.exceptions),

filter: {
matchesValue(baminfo.exception, "OK")
},
interval:
duration(toLong(substring($Interval,from:0,to:stringLength($Interval)-1)),
unit:getCharacter($Interval,stringLength($Interval)-1))

Re: Calculate a succes rate line with metrics

MaximilianoML — Wed, 06 May 2026 16:30:09 GMT

Hello @enrico_afkl!

You can try this one:

timeseries { totalCalls = sum(log.prgoffer.foapi.baminfo.golden.exceptions), successCalls = sum( log.prgoffer.foapi.baminfo.golden.exceptions, filter: matchesValue(baminfo.exception, "OK") ) }, interval: duration( toLong(substring($Interval, from: 0, to: stringLength($Interval) - 1)), unit: getCharacter($Interval, stringLength($Interval) - 1) ) | fieldsAdd successRatio = successCalls[] / totalCalls[] * 100

I hope it helps 😀

Re: Calculate a succes rate line with metrics

enrico_afkl — Thu, 07 May 2026 06:46:06 GMT

that's perfect thanks!