Expanded Date Logic for Reports and Dashboard Widgets: Before/After a Specific Date
User Story
When I {make a change}
- Launch an engagement
- Map a feature / change a feature mapping (especially if the backfill won’t pull in all of the relevant data like global context from before the new definition)
- Change something about the UX/CX
- Start a community initiative to inspire product adoption
- etc
I want to set reports and/or widgets to show data that happened {relative to that date}
- Before the date (Before the change)
- After the date (After the change)
In order to easily compare and contrast user behavior relative to that date.
AND so that I don’t have to constantly remember and/or update date ranges in my saved reports and widgets.
Ideal Requirements
- Works with existing Daily/Weekly/Monthly view options for charts in widgets
- Filters those views before/after the data set in the report or widget
- Works with Query Builder and other Analytics as a saved before/after date of the data set
Current State / Pain Point Examples
- A mapped featured does not have global context as part of the backfill. We want to have reports and widgets that filter based on global context. When sharing / editing dashboards, I find myself constantly adjusting the custom date range to start from that date … but the end date sticks as the day that I’m making the change and doesn’t update. So that view of the report/widget becomes outdated as soon as the next day.
- Same pain point for wanting to have two reports and/or widgets that show a before and after.
- Before can be set and remain static, but the after {date} would need a custom date range that’s updated regularly until the {change date} falls beyond a Last {range} setting for how we might want to view the data (last X days/weeks/month). That could be QUITE a long time if, for example, you wanted a weekly view for the next 12 weeks or a monthly view for the next 6 months (after the change)