We have a CSV fields set defined (shortening it here),
Destinations vary as well (taking a simpler case)
Trying to get something very simple then will group by Destination later on
Iam trying stuff but somehow i cant find a way to search in one search two different count values.. not sure if iam trying to do anything complex here
if i get you correct, you can use the following sample to get a
count of certain Status field values:
... | stats count(eval(Status=Pass)) as PassCount by Destination
PassCount is a new field, which is needed and can be used further.
hope this is some kind of helpful
How is such a feeling?
････|stats count as All,count(eval(Status="Pass")) as SUCCESS,count(eval(Status="Fail")) as Fail by Txn|eval "FAILURE RATE"=Fail / All | table Txn,SUCCESS,"FAILURE RATE"