Splunk Search

Add the column of numbers for the same result

mwadhwa
New Member

I have 2 columns. One of them lists IP address of which many are repeating and the other column is of purchases. The same IP has multiple purchases so I can see multiple entries. Can I club into one total purchase for a particular IP?

Thanks!

0 Karma
1 Solution

Richfez
SplunkTrust
SplunkTrust

I dont' have field names, but it should be some variant of ...

... my search here | stats sum(purchases) AS TotalPurchased by IPAddress

Give that a shot, let us know how it works for you!

Happy Splunking,

Rich

View solution in original post

Richfez
SplunkTrust
SplunkTrust

I dont' have field names, but it should be some variant of ...

... my search here | stats sum(purchases) AS TotalPurchased by IPAddress

Give that a shot, let us know how it works for you!

Happy Splunking,

Rich

Get Updates on the Splunk Community!

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...

🔐 Trust at Every Hop: How mTLS in Splunk Enterprise 10.0 Makes Security Simpler

From Idea to Implementation: Why Splunk Built mTLS into Splunk Enterprise 10.0  mTLS wasn’t just a checkbox ...