I have a dashboard that shows the percent between the total attended transactions and the transactions that have atleast an error within the relationed span traces in the transaction sent by the infinite tracing module
In the begin, I was using the property newrelic.sampling.strategy with error value a that worked excelent
but now I see that my traces does not have this attribute anymore
That broke my dashboard
So, I need a way to handle this, getting the number of transactions with at least one error, If I count the total span traces with errors this number does not works because one transaction could have more than one error trace span.
This is my query
SELECT 100 - ( 100 * filter(count(), where eventType() = ‘Span’ AND newrelic.sampling.strategy = ‘error’) / filter(count(), where eventType() = ‘Transaction’ )) as ‘%’ FROM Transaction, Span SINCE 1 day ago