How to Build Self-Updating Jira Report with Dynamic Anchors

[#1]

If you manage Jira dashboards, you know the friction of static date filters. Updating a "Last Month" or "Last Week" report shouldn't require you to manually change calendar parameters on the 1st of every month. That’s why we’ve developed the Dynamic Date Picker for Timepiece - Time in Status for Jira. It completely eliminates the busywork of managing date ranges.
 

How Dynamic Date Picker Works

Dynamic Date Picker replaces rigid filtering with a flexible system that lets you seamlessly switch between "Static" and "Dynamic" modes. Here are the core capabilities you can now use across Timepiece reports:

Static Dates or Dynamic Anchors: Lock your report to a precise calendar date (e.g., "May 1, 2026"), or use dynamic anchors (e.g., "Start of this month") to create rolling timeframes that automatically update themselves.

Mix & Match Flexibility: Combine a Static Start Date (e.g., the exact kickoff date of a Q3 epic) with a Dynamic End Date (e.g., "End of last week") to perfectly track long-term, ongoing projects without constantly adjusting the end date.

Dual Control: You can apply this date filtering to both Filter Dates and Trim Dates.

Fine-Tuning: Shift your dynamic anchor point forward or backward by precise increments using an easy up/down interface for Years, Months, Weeks, Days, and Hours.

Presets: Apply standard time frames from a built-in list, ranging from short intervals (Last 1, 3, 6, 12, 24 hours) to broader periods (This/Last Week, This/Last Month, This/Last Quarter, This/Last Year).

How It Helps

Zero-Maintenance Dashboards & Sprint Reviews

When you configure a Cycle Time gadget using a dynamic preset like "Last Month," it permanently displays the correct data. You set it once, and the dashboard maintains itself. And you can still drill down into any chart bar to see the specific Jira issues.
Imagine walking into your weekly Sprint Review or Executive Sync. Instead of scrambling for 15 minutes to manually adjust the dates on your Cycle Time report beforehand, your gadget is already dynamically synced to the exact period. You get instant visibility with zero manual effort. 

Truly Autonomous Scheduled Reports

Automate your data distribution via secure download links, email, Slack, or MS Teams. By combining the Dynamic Date Picker with Scheduled Reports, your "Daily Engineering Output" report dynamically adjusts to calculate data precisely from the "Start of yesterday" to the "End of yesterday" every single night before hitting your inbox. 

Precision Fine-Tuning for Business Hours

When tracking metrics like Lead Time and Resolution Time, a rigid dynamic filter might not align with your specific time zones. The Fine-Tuning menu allows you to shift any dynamic anchor point forward or backward by exact increments (Years, Months, Weeks, Days, and Hours). For instance, if your engineering team stops logging work at 5:00 PM on Friday, a standard 'End of this week' anchor might capture irrelevant weekend hours, skewing your averages. With fine-tuning, you can select the 'End of this week' anchor and precisely subtract hours to perfectly match your actual business closure time.

With Dynamic Date Picker, you can now focus on what actually matters: analyzing your team's velocity, identifying bottlenecks, and driving continuous improvement. To learn more about Timepiece - Time in Status for Jira and how it helps thousands of teams, visit its Atlassian Marketplace page.