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. 

View Entire Topic

Avatar

Avatar
Seeker
Level 5
David-123
Level 5

Likes

115 likes

Total Posts

135 posts

Correct Reply

18 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Springboard
Establish
View profile

Avatar
Seeker
Level 5
David-123
Level 5

Likes

115 likes

Total Posts

135 posts

Correct Reply

18 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Springboard
Establish
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