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?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Affirm 250
Moderator
PratheepArunRaj
Moderator

Likes

291 likes

Total Posts

819 posts

Correct Reply

250 solutions
Top badges earned
Affirm 250
Contributor
Springboard
Shape 1
Validate 10
View profile

Avatar
Affirm 250
Moderator
PratheepArunRaj
Moderator

Likes

291 likes

Total Posts

819 posts

Correct Reply

250 solutions
Top badges earned
Affirm 250
Contributor
Springboard
Shape 1
Validate 10
View profile
PratheepArunRaj
Moderator

21-04-2021

Dear mdep,

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.

PratheepArunRaj_0-1619023651705.png

Once created, you should see the below numbers.

PratheepArunRaj_1-1619024006526.png

But, not sure about the metric average number of visits per hour of the day, can you explain more?

Thank You, Pratheep Arun Raj B | Xerago | Terryn Winter Analytics

Answers (2)

Answers (2)

Avatar

Avatar
Boost 3
Level 2
_Analytics_Guru_
Level 2

Likes

4 likes

Total Posts

14 posts

Correct Reply

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

Avatar
Boost 3
Level 2
_Analytics_Guru_
Level 2

Likes

4 likes

Total Posts

14 posts

Correct Reply

2 solutions
Top badges earned
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

 

Avatar

Avatar
Springboard
MVP
yuhuisg
MVP

Likes

146 likes

Total Posts

476 posts

Correct Reply

90 solutions
Top badges earned
Springboard
Bedrock
Validate 1
Establish
Contributor
View profile

Avatar
Springboard
MVP
yuhuisg
MVP

Likes

146 likes

Total Posts

476 posts

Correct Reply

90 solutions
Top badges earned
Springboard
Bedrock
Validate 1
Establish
Contributor
View profile
yuhuisg
MVP

19-04-2021

---