Aggregation based on hour of day and timezone

I found some useful information at Is it possible to apply a timezone to a date in a scripted field? but it seems this approach is not best practice and has been deprecated.

I then stumbled upon https://stackoverflow.com/a/46830875 and was able to get it working with a small tweak :slight_smile:

Just not sure how well this will scale.