Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

New Date Range Preset or Segment for Completed Hours of Day


Level 9


It would be really nice if there was a date range preset or default segment that selects the current hours of the day that dynamically updates throughout the day.  For example, if its currently 10:15am, the date range or segment would select all hours of the day from 0 to 9 (The 10am hour is not complete).  Then, lets say 2 hours later, at 12:00pm, the date range or segment would now be selecting hours of the day from 0-11.  I would use this segment to power intraday 'Today' vs. '7 Days ago' reporting and calculated metrics.

To make this date range or segment even more slick and avoid issues related to data latency you could align the hours of day to fully processed data.  This capability would enhance our intraday analysis dashboards, where we currently do the following:

1. Use Today vs. 7 Days trended charts.  This works great except when you have tables with many dimension values and you are always selecting dimension values to update your charts.

2. Leverage 24 hour of day segments (0 to 0, 0 to 1, 0 to 2, 0 to 3, etc) to power reporting.  this  This works, but we always have to change the segment depending on the hour of day.