Splunk Search

Using Search Tutorial data, how to search for the total number of items sold, the best selling item, and number of the best selling item sold by country?

hcheang
Path Finder

Hi, I'm going over the search tutorial and have a question regarding the stats command.

What I'm trying to find is to find best selling item, number of best selling item sold and total number of items sold by country.

I've managed to get the stats for both best selling item and total number of items sold but not the number of best selling item sold.

My search query is

buttercup*  price=* action=purchase|iplocation clientip|stats max(productId) as "Best Seller" count as "Sold Total" by Country

I've tried count(max(productId)) which doesn't seem to work.

Can I get help or any suggestion for which command to use to get a chart like

      Country            Best Seller       Sold           Sold Total
     Argentina            WC-SH-G04         3                11

Thanks in advance!

Tags (4)
1 Solution

somesoni2
SplunkTrust
SplunkTrust

Try this

buttercup*  price=* action=purchase|iplocation clientip | stats count by productId Country  | eventstats max(count) as max by Country | eval BestSeller=if(count=max,productId,null()) | stats values(BestSeller) as "Best Seller" , first(max) as Sold, sum(count) as "Sold Total" by Country

View solution in original post

somesoni2
SplunkTrust
SplunkTrust

Try this

buttercup*  price=* action=purchase|iplocation clientip | stats count by productId Country  | eventstats max(count) as max by Country | eval BestSeller=if(count=max,productId,null()) | stats values(BestSeller) as "Best Seller" , first(max) as Sold, sum(count) as "Sold Total" by Country

sophy
Splunk Employee
Splunk Employee

This is a great example to add to the Search Tutorial. Thank you! 😄

Get Updates on the Splunk Community!

Understanding Generative AI Techniques and Their Application in Cybersecurity

Watch On-Demand Artificial intelligence is the talk of the town nowadays, with industries of all kinds ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

Using the Splunk Threat Research Team’s Latest Security Content

REGISTER HERE Tech Talk | Security Edition Did you know the Splunk Threat Research Team regularly releases ...