We have a requirement to calculate Hour Of Day Average, for example, here with I have attached sample data.
we have a below data set, Hour Of Day (01:00, 02:00, 03:00, 04:00), Date/Day Number and Total Visits.
Based on that I’m trying to calculate “Avg Hourly Visits”, But can’t figure out how to use formula for it .
Avg Hour Visits = (total Visits / Count of Days/Date ) and group By Hours Of Day.
Sample data attached in the screenshot.
Thank you in Advance.