Rolling Hour of Day

Avatar

Avatar
Validate 1
Level 1
deion
Level 1

Like

1 like

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Ignite 1
Boost 1
View profile

Avatar
Validate 1
Level 1
deion
Level 1

Like

1 like

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Ignite 1
Boost 1
View profile
deion
Level 1

12-04-2021

I am attempting to make an hourly dashboard in which the hour of today ex 5 PM is compared to the same exact hours yesterday. I've created a few multiple segments such as 24 individual segments with exclusions to create a rolling hourly comparison, however, none of my attempts have worked. Is anyone aware of a way to show a daily comparison of performance at the hourly level which excludes hours that haven't happened in the day vs. Yesterday only shows hours which are equivalent to Today. 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile

Avatar
Shape 10
Level 6
David-123
Level 6

Likes

118 likes

Total Posts

141 posts

Correct reply

20 solutions
Top badges earned
Shape 10
Ignite 3
Seeker
Bedrock
Engage 1
View profile
David-123
Level 6

14-04-2021

Hi There,

 

I have managed to solve this for you.

 

The first thing you need is a "5pm Visit" such as below:

 

David-123_0-1618407874684.png

 

Then you need the following:

David-123_1-1618407939509.png

Change Number "7" for the period you want to look back.

So if your report is showing days, it will be 7 days, if it is weeks it will be 7 weeks.

 

I hope that helps.

 

Dave

 

 

Answers (2)

Answers (2)

Avatar

Avatar
Affirm 5
Level 2
akt0m3r
Level 2

Likes

8 likes

Total Posts

31 posts

Correct reply

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

Avatar
Affirm 5
Level 2
akt0m3r
Level 2

Likes

8 likes

Total Posts

31 posts

Correct reply

5 solutions
Top badges earned
Affirm 5
Establish
Boost 5
Boost 3
Boost 1
View profile
akt0m3r
Level 2

13-04-2021

Hi @deion, could you please try using the "Hour of Day" metric for automaton and see if that helps!

Avatar

Avatar
Boost 25
Level 3
amgup
Level 3

Likes

26 likes

Total Posts

133 posts

Correct reply

16 solutions
Top badges earned
Boost 25
Affirm 10
Boost 5
Boost 3
Boost 10
View profile

Avatar
Boost 25
Level 3
amgup
Level 3

Likes

26 likes

Total Posts

133 posts

Correct reply

16 solutions
Top badges earned
Boost 25
Affirm 10
Boost 5
Boost 3
Boost 10
View profile
amgup
Level 3

12-04-2021

@deion If I am right than you want to compare the data from the previous day on hourly basis. To achieve this you can right click on metric name in Workspace project -> Click on Add Time Period column -> click on Prior date range to this date range. Than use the hour dimension to compare the data on hourly basis with previous date.

Refer the below screenshot :-

amgup_0-1618284518260.png