Next level project management reporting with Sprints and Parent Issues

We're thrilled to announce a major update focused on simplifying your reporting workflows with the introduction of dedicated fields for Sprints and Parent Issues. Say goodbye to cumbersome custom fields and hello to advanced (yet streamlined) insights! 🧘

Jira Sprints: Deeper visibility on SCRUM iterations

With this release, you no longer need to juggle with array-based custom fields to get sprint information. We've mapped Jira sprints directly into our data model, adding six new, dedicated fields. These new fields make past, current, and future sprint reporting drastically easier and pave the way for enhanced sprint-based dashboards 🏃

These fields expose the attributes of the most relevant sprint associated with each issue:

• Past Sprint Names: The list of sprint names the issue has gone through before the currently associated sprint.
• Sprint Closed At: The closure date of the sprint associated with the issue.
• Sprint End At: The end date of the sprint associated with the issue.
• Sprint Name: The name of the sprint associated with the issue.
• Sprint Start At: The start date of the sprint associated with the issue.
• Sprint State: The state (closed, active, future) of the sprint associated with the issue.

Here are some typical scenarios where these new fields will be useful. If you want to see:

• A retrospective view of issues from closed sprints, use the filter "Sprint State = CLOSED"
• Issues in a currently active sprint, use the filter "Sprint State = ACTIVE"
• Issues that are scheduled in a future sprint, use the filter "Sprint State = FUTURE"
• Issues that were previously in sprint XXX but have been carried over to another sprint, use the filter "Past Sprint Names contains XXX"
• A distribution of the number of issues allocated to current and future sprints, use a pie chart with "Sprint State" as dimension.

Parent Issue Attributes: Epic-level reporting

We're also excited to introduce Parent Issue attributes, which allow you to easily filter issues based on their parent issue (e.g., Epics). Jira and GitHub both support parent issues, such as Epics in Jira or parent issues in GitHub. This feature provides valuable context and enables more granular reporting, allowing you to understand how individual issues contribute to larger initiatives.

A typical reporting scenario is to calculate the percentage of progression of Epics based on how many issues are associated with them and how many have been closed so far. With this new release, it is only a matter of grouping issues by parent attributes and using a formula of type COUNT_IF(state = "CLOSED")/COUNT to get a percentage of progression. That's it! 🔥

Other improvements and bug fixes

• Improvement: Support Microsoft Entra (previously known as Active Directory) as a login option
• Improvement: Parent custom fields (Jira custom fields) are now exposed on Activity Events & Comments.
• Improvement: Parent story points are now exposed on Activity Events & Comments.
• Improvement: Parent key is now exposed on Activity Events, Comments and Commits.
• Improvement: Custom Formula: Improved the editing experience of Custom Formulas with better bracket highlighting/matching as well as better field highlighting/selection.
• Improvement: New ARRAY_FILTER operator for Custom Formulas, allowing one to filter a list of values based on a regex.
• Improvement: Support the explicit use of null values in Custom Formulas. NULL values get ignored in aggregation metrics. Being able to explicitly use null values in formulas is useful when you want to do conditional aggregations. E.g., an average of "big PRs" such as AVG(lines_changed > 1000 ? lines_changed : null).
• Improvement: Array arithmetics for Custom Formulas - elements can now be added to an array using the + sign. E.g. label_names + ['bug'] or label_names + 'bug'
• Improvement: Array arithmetics for Custom Formulas - elements can now be removed from an array using the - sign. E.g. label_names - ['bug'] or label_names - 'bug'
• Improvement: Dashboards can now be set as viewable or editable by the whole team (team-wide sharing).
• Improvement: On top of exposing properly mapped sprint attributes, the Jira "sprints" custom field is now also sorted consistently by sprint completion date, with the current/future sprint always last (Jira does not return a specific order on its API).
• Improvement: Field picker dropdowns now support filtering via multiple keywords (instead of filtering based on the whole sentence).
• Improvement: A new insight named "Reopen Rate" has been added to the library. It displays the ratio of issues reopened versus issues created.
• Improvement: Two new insights named "Burndown chart" (based on count or story points) have been added to the library.
• Improvement: A new insight named "Open at date" has been added to the library. It displays the number of open items (Issues and PRs) at any given point in time alongside the cumulative count of created/reopened and closed/merged events."
• Improvement: Performance improvements have been released to the "Issues & Pull Requests" and "Reviews" datasets, boosting reporting speed by up to x100.
• Bugfix: Fixed an issue with some array operators considering null values as empty arrays, creating an offset for some advanced count formulas.
• Bugfix: Fixed an issue where the drilldown was incorrectly working on multi-dimensional charts in some rare scenarios.