"call" OR "exception1" OR "exception2" OR "exception3"
| eval calls = if(like(message, "%call%"), 1, 0)
| eval errors1 = if(like(message, "%exception1%"), 1, 0)
| eval errors2 = if(like(message, "%exception2%"), 1, 0)
| eval errors3 = if(like(message, "%exception3%"), 1, 0)
| eval errors = errors1 + errors2 + errors3
| eval allErrorsPerMile = round((errors*1000) / calls, 3)
| stats sum(allErrorsPerMile), sum(errors1), sum(errors2), sum(errors3), sum(errors), sum(calls)
Straight to the point: "calls" eval do not work in calculations
allErrorsPerMile = round((errors*1000) / calls, 3)
even though im sure it contains some value(it can be seen on the screenshot)
Im also sure the
| eval allErrorsPerMile = round((errors*1000) / calls, 3)
works becouse if i put a number instead of "calls" it calculates it
Whats wrong there? maybe I should approach the problem differently?
... View more