Our organization aims to determine the most common times of day when users open messages from specific campaigns. We want to know whether they tend to open them in the morning, early afternoon, late afternoon, or other times.
When creating a report, we have Time dimensions available for Day, Hour, Minute, Month, and Quarter. However, the Hour dimension currently only specifies the hour of a particular day (such as 9:00 AM on April 1, 2023), not the hour of a general day (such as 8:00 AM - 8:59 AM)