Hi PratheepArunRaj, that worked! nice for average number of visits per weekday too!

Hi Pratheep,Thank you for your response.Here's what I'm after: I'm trying to find out the most popular hour to visit the site on average. Instead of just summing visits per hour I want to take the average. Like this:Date1AM2AM3AM4AM5AM6AM7AM4/1/20212124610204/2/20214005411224/3/2021113561219Average2...

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