Splunk Search

How would I remove duplicates but add up their counts?

Ragate
Explorer

I have two sources of data. One that has an Account Name, License Key, and Account Revenue. The other has License Key and an Item_Count field.
Current it shows like this
LicenseKey Item_Count
200IGN3 4
200IGN3 10
342mD3D 8
342mD3D 6

I would like to remove the duplicate keys and add up there item counts.

How would this be done?
Thanks in advance.

0 Karma

somesoni2
Revered Legend

Try like this

your current search showing fields LicenseKey Item_Count
| stats sum(Item_Count) as Item_Count by LicenseKey
0 Karma
Get Updates on the Splunk Community!

Splunk Decoded: Service Maps vs Service Analyzer Tree View vs Flow Maps

It’s Monday morning, and your phone is buzzing with alert escalations – your customer-facing portal is running ...

What’s New in Splunk Observability – September 2025

What's NewWe are excited to announce the latest enhancements to Splunk Observability, designed to help ITOps ...

Fun with Regular Expression - multiples of nine

Fun with Regular Expression - multiples of nineThis challenge was first posted on Slack #regex channel ...