New Issue Cycle Time Dashboard for Jira & Trello, Quarterly Grouping in Charts, and Value Picker in Configuration Assistant

This week's release delivers a new dashboard that leverages the Time in Column feature released some time ago. It also includes a couple of improvements related to time series and our beloved configuration assistant 💪

New dashboard: Issue Cycle Time for Jira & Trello

A few months ago we released a series of fields and operators allowing people to report the time spent by Jira & Trello issues into a given status ("Time in Column" feature). These features unlocked very advanced reporting capabilities via custom formulas. However, we were still missing a fully-featured and preconfigured dashboard using the Time in Column field and operators.

The wait is over! To complete our existing Pull Request Cycle Time dashboard, which focuses on core development, we just released an Issue Cycle Time dashboard that analyzes the time spent by issues in their various delivery stages.

The dashboard groups your Jira statuses into four key phases, to facilitate reporting:

• Pickup Time is the total duration spent in the initial status before the development starts (e.g. “To Do”)
• Implementation Time is the total duration spent in the development status (e.g. “In Progress”)
• Quality Assurance (QA) Time is the time it takes to verify that the implementation matches the business objectives (e.g. "In Testing", "In QA")
• Release Time is the time it takes to move the issue to production (E.g. "Ready to Release", "Pending Release Approval").

Our Configuration Assistant allows you to specify the list of Jira/Trello statuses to include in each phase:

Easy enough! Now you can get a detailed view of how long issues spend in each column of your Scrum or Kanban board 😎

Time series: Quarterly grouping in charts

On top of the yearly, monthly, weekly, and daily groupings, we have added the ability to group time series per quarter.

Need to check how you performed this quarter compared to the previous quarter? Now you can 😁

‍

As part of this new feature, we also added two operators to the library of custom formula functions:

• YEAR_QUARTER(datetime), which formats a timestamp field in YYYY-Qx format (e.g. “2023-Q2”)

• QUARTER(datetime), which returns the quarter number for a given date (or the duration of a quarter in seconds when no arguments are provided)

Configuration Assistant simplified thanks to value pickers

Value pickers were already available for insight filters and dashboard-wide filters. But they were still missing in our Configuration Assistant.

Well, good news everyone, they're now available there as well! Picking statuses, labels, and commit keywords while configuring a dashboard or an insight is now dead easy! Just pick the value that is the most relevant to the question.

Check out the gif above to see an example of a value picker in action ⛏️

New presets available for dashboard-wide filters

On top of the existing Reporting Period and Projects presets, you can now quickly create dashboard-wide filters using the App and the Owners fields.

The Owners field was introduced as part of the previous release. Its objective is to facilitate filtering across issues and pull requests, and help identify who is responsible for a given item:

• For issues: the Owners field is equal to the assignees field
• For pull requests: the Owners field is equal to the author field (list with a single element)

Some improvements and bug fixes

A few additional items worth mentioning 😉

• Improvement: Associations between PRs and Jira issues now support using the issue key in branch names (case insensitive) and commit messages (without an auto-closing keyword)
• Improvement: Expand the catalog of errors supported in a human-friendly way when connecting GitLab/Jira hosted instance
• Improvement: The search bar in the insight library now only filters insights based on their title and tags, and no longer uses their description. The use of the description for filtering was returning too many results due to the popularity of certain keywords.
• Bugfix: The due date for issues attached to sprints now uses the last sprint due date instead of the last active sprint due date. The latter was leading to due dates disappearing once a sprint was completed.
• Bugfix: The CONCAT operator now supports decimal arguments (was returning an error before)
• Bugfix: the unit helpers such as YEAR, MONTH, WEEK, etc. now return a proper integer instead of a stringified integer. This could cause issues when trying to apply a math operation on the return value of these operators.
• Bugfix: Fixed an issue where a Jira user changing name then being rolled back would not be reflected on the Keypup side