Monitoring Splunk

how to add columns having Alphabetically/string data and display the count?

Ashwini008
Contributor

Hi,

I have below data in lookup,i need to add up the row data

example: For first row i need to add total offw,total 'B',total 'V' and show the count in 3 different column for OFF,B and V.

Similary for each row i need add the same data value and show in a column

 

Ashwini008_1-1629725806010.png

any query or commands ?

Labels (1)
Tags (3)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
| rename count(FieldValue) as count
| table Names FieldValue count
| xyseries Names FieldValue count

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust

Assuming you can't get to the data before it has been put in this format, you could try untable to reverse the xyseries, then count the various values by whatever that first column is.

0 Karma

Ashwini008
Contributor

@ITWhisperer Thank You.I got it in below format using the untable command.

Ashwini008_1-1629805260690.png

How can i get in the below format.

Names

A

B

C

XYZ

11

4

7

 

 

 

 

 

 

 

 

 

 

 

 

Tags (2)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| rename count(FieldValue) as count
| table Names FieldValue count
| xyseries Names FieldValue count

View solution in original post

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!