Splunk Search

Convert confusion matrix to tabular form

dalmaua
Engager

Hi,

I am trying to convert the result of applying the CorrelationMatrix algorithm which is given in a confusion matrix form like:

        AA     BB     CC

AA   1        0.1    0.2

BB    0.1     1      0.3  

CC   0.2     0.3    1

And I would like to convert it to a tabular form like:

AA BB 0.1
AA CC 0.2
BB AA 0.1 
BB CC 0.3
....

So far I tried with the untable command without success. Below you can see a sample of the code I have.

 

 

index="someIndex" 
| timechart span=1m count by someField
| fillnull value=0
| fit CorrelationMatrix method=pearson * 
| untable a, b, c

 

 

 

Any help would be much appreciated, 

Thanks!

 

Labels (1)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

Assuming the first column is called index

| makeresults 
| eval _raw="index AA     BB     CC
AA    1        0.1    0.2
BB    0.1     1      0.3  
CC   0.2     0.3    1"
| multikv forceheader=1
| table index AA BB CC


| untable index name value
| where index!=name

View solution in original post

0 Karma

dalmaua
Engager

Thanks, it worked!

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Assuming the first column is called index

| makeresults 
| eval _raw="index AA     BB     CC
AA    1        0.1    0.2
BB    0.1     1      0.3  
CC   0.2     0.3    1"
| multikv forceheader=1
| table index AA BB CC


| untable index name value
| where index!=name

View solution in original post

0 Karma
Did you miss .conf21 Virtual?

Good news! The event's keynotes and many of its breakout sessions are now available online, and still totally FREE!