I need a search that shows me the count of the produtcs weekly
products countfromweek1 countfromweek2 date
product1 10 6 2020-09-07 to 2020-09-13
product2 20 16 2020-09-14 to 2020-09-21
-- your search
| bin span=1w _time
| stats count by product, _time
Not sure what the date column is supposed to relate to in your example
I need to create a table that shows me the total count from last 3 weeks. Like:
Produtcs Total Count from week1 Total count from week2
A 14 10
B 5 8
C 8 3