Hi David, thank you for the response and logic. So an additional question. If i need a full 23 hour coverage, would I just need to replicate the 5pm hour setup 22 additional times? Or does this change your process at all?

Hi Amgup, Thank you for the response, so I' m aware of this version. I think I need to explain a bit further, I'm attempting to make this automated with rolling dates which presents the issue, that I can get it to perform as noted when manually building it, however, upon attempting to automate this ...

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...