Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Average visits per hour of day

Avatar

Avatar
Validate 1
Level 1
mdep
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
mdep
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
mdep
Level 1

16-04-2021

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: 

mdep_0-1618603133084.png

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:

mdep_1-1618603259012.png

How do i get the average number of visits that I can break down by hour of day?

View Entire Topic

Avatar

Avatar
Affirm 3
Level 2
_Analytics_Guru_
Level 2

Likes

4 likes

Total Posts

14 posts

Correct Reply

3 solutions
Top badges earned
Affirm 3
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Affirm 3
Level 2
_Analytics_Guru_
Level 2

Likes

4 likes

Total Posts

14 posts

Correct Reply

3 solutions
Top badges earned
Affirm 3
Boost 3
Boost 1
Affirm 1
View profile
_Analytics_Guru_
Level 2

25-04-2021

@mdep 

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.

AnalyticsLord_0-1619339369963.png