Dear Splunkers,
The result of my search is like :
TXID,STATUS_A,STATUS_B,STATUS_C
A,OK,OK,OK
B,OK,KO,INPROGRESS
C,OK,OK,KO
D,OK,KO,KO
E,KO
Transaction E has no STATUS_B nor STATUS_C fields
What i'am trying to get is a count over all STATUS columns :
STATUS_NAME,OK_COUNT,KO_COUNT,INPROGRESS_COUNT
STATUS_A,4,1,0
STATUS_B,2,2,0
STATUS_C,1,2,1
Any hints are welcome.
Thank you
| untable TXID status result
| stats count by status result
| xyseries status result count
| untable TXID status result
| stats count by status result
| xyseries status result count