Following on from this thread, I discovered I cannot return error rate from APM Transaction.
FROM Transaction SELECT filter(count(*), WHERE error IS true)
The above query returns 0, despite there being 120 results from
FROM TransactionError SELECT count(*). Why the discrepancy?
As a workaround, I’ve been using the following to return the error rate.
FROM Metric SELECT count(apm.service.error.count) / count(apm.service.transaction.duration) * 100 WHERE appName LIKE '%'
What do you think about this? Can it be formatted better?
I know that Transaction has
request_uriwhich allows you to break out by URIs. Is there an equivalent for Metric?
Thanks for your time.