Columns to rows and count

[Atif]

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

[ITWhisperer · Accepted solution]

| untable TXID status result
| stats count by status result
| xyseries status result count