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.
I have managed to solve this for you.
The first thing you need is a "5pm Visit" such as below:
Then you need the following:
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.
@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 :-