Splunk Search

Count within count

sauravdhungel
Engager

 I have a data and created a table like this:

EligibilityCount
01-Country31

 

Now I would like to see how those country are counted to 31 . The output would be like this:

Countriescount
GERMANY4
MALAWI10
SERBIA6
SRI LANKA5
SWAZILAND1
UKRAINE5

 

Any help will be greatly appreciated. Thank you

Labels (1)

ITWhisperer
SplunkTrust
SplunkTrust

Without knowing what your data looks like, assuming you already have a field called countries in your events:

| stats count by countries
Get Updates on the Splunk Community!

Pro Tips for First-Time .conf Attendees: Advice from SplunkTrust

Heading to your first .Conf? You’re in for an unforgettable ride — learning, networking, swag collecting, ...

Raise Your Skills at the .conf25 Builder Bar: Your Splunk Developer Destination

Calling all Splunk developers, custom SPL builders, dashboarders, and Splunkbase app creators – the Builder ...

Hunt Smarter, Not Harder: Discover New SPL “Recipes” in Our Threat Hunting Webinar

Are you ready to take your threat hunting skills to the next level? As Splunk community members, you know the ...