I will answer my own question here finally found it.
search term | case () | streamstats fieldnames ,_raw,_time
streamstats/event stats takes you to events rather then statistics and calculates the statistics per each even
Lets say you have a
stats count as ProductCount by product_name then stream stats will set ProductCount to 1 for first event then 2 for 2nd event and so on for product_name=Ferrari and if u have a BMW as a product it will reset from 1 again for those events.
... View more