Monitoring Splunk

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

Ashwini008
Builder

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
Builder

@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
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...