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 it all goes down hill haha.
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
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.