I'm having trouble formulating a search query for the following data:
When the number of "tests-failed" has exceeded 20% of "tests-total".
How do you do percentages?
P.S. i'm working with metrics data.
Use eval
| eval percent=round(testsfailed/teststotal*100,2)
Assuming your field names are as above. If you want to use 'tests-failed' and 'tests-total' then you need to wrap those field names in single quotes in the eval statement.