Splunk Search

Problem with the counting

abhayneilam
Contributor

Hi,

I have a data like :
Name 1 2 3 4 5


abc 0 2 5 0 18
def 3 0 10 10 11
ghi 0 0 0 7 20

Now, I have 6 columns as "Name" , 1, 2, 3,4,5
I want my output as :

abc 3 ---> 3 becaue there are total of 3 more than 0 number against "abc" name
def 4 ---> 4 becaue there are total of 4 more than 0 number against "def" name
ghi 2 ---> 2 becaue there are total of 2 more than 0 number against "ghi" name

Please help in getting this thing done.

Thanks in advance !!

Tags (4)
0 Karma

martin_mueller
SplunkTrust
SplunkTrust

Here's a thought: Replace every non-zero number with a one, then sum up all columns.

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

Not knowing the column names is no problem, addtotals will add together a total of all numerical columns.

All you'd have to do for that to work is to get the cells as either 1 or 0.

0 Karma

Ayn
Legend

Could you please stop ending all your posts with "please help"? 😛

0 Karma

abhayneilam
Contributor

But i dont know my column names in this case, only "Name" column is fixed but not "1","2","3","4","5", these no can changes month to month, Moreover I dont have to summing up the no. I have to get the count for the number which is more than 0

"abc" name is having 2,5 and 18( count is more than 0 ) in the above mentioned details , so against "abc" the total count will be 3

Please help

0 Karma
Get Updates on the Splunk Community!

Developer Spotlight with Brett Adams

In our third Spotlight feature, we're excited to shine a light on Brett—a Splunk consultant, innovative ...

Index This | What can you do to make 55,555 equal 500?

April 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this ...

Say goodbye to manually analyzing phishing and malware threats with Splunk Attack ...

In today’s evolving threat landscape, we understand you’re constantly bombarded with phishing and malware ...