I have this string and I want the output for this result to be combined on one line and also sum the results
index="grade-stat" host ="student" source="exam"|
eval Result=case(match(_raw,"Pass"),"Result Successful",
match(_raw,"Fail"),"Result failed" ) | stats count by Grade, Result
**current output
Grade-A Result Successful 125675
Grade-A Result failed 4004
Grade-B Result Successful 145134
Grade-B Result failed 2695
***desired result
Grade-A Result Successful 125675 Result failed 4004 total= 129679
Grade-B Result Successful 145134 Result failed 2695 total= 147824
What I need is the output to be on same line instead 2 lines for each grade, and if possible, to sum the success and failed count.
thanks,
... View more