topic Re: Grail code help in DQL

Grail code help

derija — Wed, 15 Oct 2025 12:21:01 GMT

Here is my code related to area trying to get the percentage of 5xx. I seem to have all the data here but the simple math is not working out...Any help?

| summarize { dur_msAvg=avg(duration), dur_msMax=max(duration), dur_msMin=min(duration), dur_medMin=median(duration),
failedRequests300 = countIf(http.response.status_code >= 300 and http.response.status_code < 400),
failedRequests400 = countIf(http.response.status_code >= 400 and http.response.status_code <500),
failedRequests500 = countIf(http.response.status_code >= 500),
successfulRequests = countIf(http.response.status_code == 200),
allRequests = count(),
rate5xx = countIf( toDouble((failedRequests500 / allRequests) * 100) <> 0) },
by:{service.entity.name, endpoint.name, appName}

output:

Re: Grail code help

fstekelenburg — Mon, 13 Oct 2025 16:23:12 GMT

Perhaps (since it involves percentage) you could calculate the percentage directly, like this?

rate5xx = toDouble(failedRequests500) / toDouble(allRequests) * 100

Remarks:
- toDouble() ensures you're doing floating-point division.
- I don't think you need to wrap the percentage calculation in countIf — that’s only for counting events that match a condition.

Re: Grail code help

derija — Mon, 13 Oct 2025 16:40:23 GMT

Thanks for the option when I just try straight math whether I use toDouble or not I get

Re: Grail code help

derija — Mon, 13 Oct 2025 18:47:38 GMT

Here is the fix...I had to END the summarize, then include the field...subtle but I missed it..

|summarize by:{service.entity.name, endpoint.name, appName},
{ dur_msAvg=avg(duration), dur_msMax=max(duration), dur_msMin=min(duration), dur_medMin=median(duration),
failedRequests300 = countIf(http.response.status_code >= 300 and http.response.status_code < 400),
failedRequests400 = countIf(http.response.status_code >= 400 and http.response.status_code <500),
failedRequests500 = countIf(http.response.status_code >= 500),
successfulRequests = countIf(http.response.status_code == 200),
allRequests = count()}
|fieldsAdd rate5xx = if(allRequests > 0, toDouble(failedRequests500) / toDouble(allRequests) * 100)
|fieldsAdd rate4xx = if(allRequests > 0, toDouble(failedRequests400) / toDouble(allRequests) * 100)

Re: Grail code help

ZackE — Mon, 13 Oct 2025 19:03:14 GMT

The issue is that you're trying to reference fields created within the same summarize command and that isn't possible. You will have to do something like this:

rate5xx = toDouble(countIf(http.response.status_code >= 500) / count() * 100)

EDIT: I see that you found a solution.