I'm trying to chart the exception rate of various apps that we run, and would ideally be generating a table that looks like this:
App ID | Exception | Number of ops with this exception | Total number of ops for this app
However, I haven't quite been able to get it working. The closest I have is this:
... | stats count as total_count, count(exception) as exception_count by app_id, exception
This isn't quite right since it only finds operations where an exception isn't null. Thus, for every row in the output table, total_count = exception_count. It seems like I need to find all operations, then filters by app_id, then finds the total_count, then filter by exception, then find the exception_count. What's the best way to do this?
... View more