I need to get the amount of users per web product every 5 minutes, grouped by 15 second bins. However, I need those 15 seconds to overlap since I need a data bin every 5 seconds. So it would be like:
Seconds 1-15 product1 amount
Seconds 1-15 product2 amount
Seconds 1-15 product3 amount
Seconds 5-20 product1 amount
Seconds 5-20 product2 amount
Seconds 5-20 product3 amount
Seconds 10-25 product1 amount
Seconds 10-25 product2 amount
Seconds 10-25 product3 amount
...
I got the search for the 15 seconds bins but I cannot get around to overlap them (btw, I am really new to this, it took me some tome to get to this point):
query
| bin _time span=15s
| stats count by products _time '
I also tried timechart but couldn't find a way to add the products field to the results.
I appreciate any comments on this!
... View more