Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

New Date Range Preset or Segment for Completed Hours of Day

Avatar

Level 9

7/20/18

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.  

2 Comments