Hi, I'm trying to calculate the average number of visits per hour of day over a given time period. When I create an Average Visits metric like this:
and then use that to breakdown by the Hour of Day dimension, I would expect it to give me the average per hour of day, however, it gives me only one value: the average of the entire selected time period. Like this:
How do i get the average number of visits that I can break down by hour of day?
Are you looking for the average hourly visits in a day i.e. Visits in a day / 24? Or average hourly visits for the time period selected i.e. Visits for the time period / No. of hours for the time period? If yes, create a calculated metric based on the below.
Once created, you should see the below numbers.
But, not sure about the metric average number of visits per hour of the day, can you explain more?
Hoping this should solve the problem without creating any additional metrics. Where the Bars are showing the maximum visits in a particular hour from Jan-Feb in this case. Make sure to update the Date range or feel free to use the Rolling date range.