I got data of each transaction with a customer_id in it If I want to know the daily average of count per hour, what search command should I use? e.g. day 1, 23-24hr is 1000 count, day 2 23-24 hr is 1200 count, then the average of these 2 day on 23-24 hr should be 1100 count I tried sourcetype=”purchase” | stats count(customer_id) AS hit BY date_hour | stats avg(hit) By date_hour However the result I get is a sum of count per hour over several days instead of an average. e.g. getting 23-24 hr is 2200 count instead of 1100 count as I want. ... View more