Tracking Sprint-Based Production Deployments

Dear @eazyBIquestion,

I need to create a report to display tickets deployed in a specific sprint. If a ticket is deployed to production, the field Actual Production Date will be updated with the deployment date. These tickets might not be tagged to a sprint, but they should still be included based on the Sprint Start Date and Sprint End Date.

The report should allow filtering by sprint name and display tickets where the Actual Production Date falls between the sprint’s start and end dates.

Additionally, the report should provide a summary of tickets deployed to production, including:

  • The number of unique deployment dates in the sprint (based on distinct values in the Actual Production Date field).
  • The total number of tickets deployed to production.

Hi, @gvparthi

Welcom to the eazyBI community.

To filter issues where the Actual Production Date falls within the Sprint Start Date and Sprint End Date, you can use the DateBetween function to select all relevant dates within that period. Learn more about this function here: DateBetween Documentation.

Next, filter the relevant issues while ignoring the selected sprint, as the issues are not necessarily added to the sprint. Your final formula should look like this:

Count(
  Filter(
    [Time].[Day].DateMembersBetween(
      DateWithoutTime([Sprint].CurrentHierarchyMember.Get('Start date')),
      [Sprint].CurrentHierarchyMember.Get('End date')
    ),
    (
      [Measures].[Issues with Actual Produciton Date],
      [Sprint].CurrentHierarchy.DefaultMember
    ) > 0
  )
)

Kindly,
Ilze