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.
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
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
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?
Thank you elliotproebstel, this is helpful.
Glad to help!
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.
Try this!
(your search)|stats sum(Price) as Total by Category,CategoryGroup