Hi ,

Good Day,

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.

Jatin.