Splunk Search

Hi, Can i use sum and list command in single query

deepa_purushoth
Engager

For example,
Category | CategoryGroup |Price
AAA|Apple |80
AAA|Apple |90
BBB|Banana|40
BBB|Butterfruit|90

I want to display my data as
Category|CategoryGroup|Total
AAA|Apple|170
BBB|Banana|40
|Butterfuit|90

Please advice.
I tried i can able to get the category and categorygroup in list however i cant do sum, but i can show as count.

Tags (1)
0 Karma
1 Solution

elliotproebstel
Champion

Yes, you can simply add the stats list() after the sum:

your search| stats sum(Price) AS Total BY Category,CategoryGroup | stats list(CategoryGroup) AS CategoryGroup list(Total) AS Total BY Category

View solution in original post

elliotproebstel
Champion

Yes, you can simply add the stats list() after the sum:

your search| stats sum(Price) AS Total BY Category,CategoryGroup | stats list(CategoryGroup) AS CategoryGroup list(Total) AS Total BY Category

elliotproebstel
Champion

Hi @deepa_purushothaman - thanks for the upvote! If this solution works for you, will you accept it, so that other users can find it if they have the same question?

0 Karma

deepa_purushoth
Engager

Thank you elliotproebstel, this is helpful.

0 Karma

elliotproebstel
Champion

Glad to help!

0 Karma

deepa_purushoth
Engager

Thank you, but this yields me duplicate value in Category. I want to include list command as well to eliminate show as multiple record under each category.

0 Karma

HiroshiSatoh
Champion

Try this!

(your search)|stats sum(Price) as Total by Category,CategoryGroup
0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...