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

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 (0)

Answers (3)

Answers (3)

Avatar

Avatar
Validate 10
Level 5
David-123
Level 5

Likes

110 likes

Total Posts

130 posts

Correct Reply

17 solutions
Top badges earned
Validate 10
Validate 1
Contributor
Give Back 5
Give Back 3
View profile

Avatar
Validate 10
Level 5
David-123
Level 5

Likes

110 likes

Total Posts

130 posts

Correct Reply

17 solutions
Top badges earned
Validate 10
Validate 1
Contributor
Give Back 5
Give Back 3
View profile
David-123
Level 5

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

 

 

Avatar

Avatar
Establish
Level 2
akt0m3r
Level 2

Likes

7 likes

Total Posts

28 posts

Correct Reply

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

Avatar
Establish
Level 2
akt0m3r
Level 2

Likes

7 likes

Total Posts

28 posts

Correct Reply

4 solutions
Top badges earned
Establish
Boost 5
Boost 3
Boost 1
Affirm 3
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 5
Level 2
amgup
Level 2

Likes

10 likes

Total Posts

38 posts

Correct Reply

7 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Affirm 5
View profile

Avatar
Boost 5
Level 2
amgup
Level 2

Likes

10 likes

Total Posts

38 posts

Correct Reply

7 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Affirm 5
View profile
amgup
Level 2

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