Splunk Search

Total count from 3 last weeks

justeso1
Loves-to-Learn Everything

Guys, I need to create a table where I have the total of products from each week.  Like 

Products     Total count from week1    Total count from week2       Total count from week3

A                                 10                                                     5                                               7

B                                  15                                                    6                                              13

C                                   20                                                  10                                            21

Labels (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
-- your search
| bin span=1w _time
| stats count by Product, _time
| xyseries Product _time count
| addcoltotals
0 Karma

isoutamo
SplunkTrust
SplunkTrust

Hi


First normal stats and then addtotals to get totals

...
| stats sum(*) as * by Products
| addtotals

r. Ismo 

0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In December, the Splunk Threat Research Team had 1 release of new security content via the Enterprise Security ...

Why am I not seeing the finding in Splunk Enterprise Security Analyst Queue?

(This is the first of a series of 2 blogs). Splunk Enterprise Security is a fantastic tool that offers robust ...

Index This | What are the 12 Days of Splunk-mas?

December 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...