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

So I want to create an alert system where the alert will only trigger if X amount of orders happens repeatedly, say for example three consecutive hours of zero orders. I've tried multiple ways to achieve this fail safe. Please let me know if anyone has any logic to create this.