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?
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.