Hi. How do I get from the first table to look like the second table?
I have tried chart, transpose, different combination of eval and stats functions but just cannot get it to look right. I am working off a csv data set.
Add the following to the search you used to generate the first table:
| stats sum(eval(if(status="failure",1,0)) as Failure, sum(eval(if(status="success",1,0)) as Success by Platform, Instance, Group, Container
View solution in original post
You are a genius. The most simple solution is always to right solution.