How to visualize %failed and order by this value descending?


I have status events of function calls in elastic. Status can be ok, error, etc. There are more than 100 different functions which can be called.

I want to visualize following use case:

  • function which has highest percentage of non-ok messages
    percentage = (all status except ok) / (ok + all status except ok)
    I want to see broken functions, even if they are barely used (by count).

I found a solution with external plugin enhanced table ( to get the data I need, but to visualize in a chart would be really nice.

You can try this in TSVB, by using the Math aggregation to calculate that percentage.