Skip to main content
DannyPancratz
VIP ⭐️⭐️⭐️⭐️⭐️
July 15, 2025
New Idea

Expanded Date Logic for Reports and Dashboard Widgets: Before/After a Specific Date

Related products:PX Analytics
  • July 15, 2025
  • 0 replies
  • 20 views

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)