To Check the deployment counts based on field

Questions & Answers
, ,
1

Dear @es_eazyBI

I need an eazybi report to show the below values

How many tickets status were changed from closed to live status in this sprint ?
In which date the ticket status were changed from closed to live status ?
How many distinct dates were there when status changed happened ?

Report should look like below.

Column 1 Column 2 Column 3 Column 4
Sprint Tickets Changed Date of Changes Distict Date
Sprint 01 8 01 Jan 2024, 04 Jan 2024 2
Sprint 02 4 07 Jan 2024 2

is it possible?

2

Hi @gvparthi

You can define three calculated measures in the Measures dimension.
Tickets Changed
This measure will return the number of issues that transitioned from the Closed status to the Live status.

(
  [Measures].[Transitions to status issues count],
  [Transition Field].[Status],
  [Transition].[Closed => Live]
)

Date of Changes
This measure will return a comma-separated list of dates in which these transitions occurred. This list will include each date only once.

Generate(
  Filter(
    [Time].[Day].DateMembersBetween(
      [Sprint].CurrentHierarchyMember.Get('Start date'),
      CoalesceEmpty(
        [Sprint].CurrentHierarchyMember.Get('Complete date'),
        [Sprint].CurrentHierarchyMember.Get('End date')
      )
    ),
    (
      [Measures].[Transitions to status],
      [Transition Field].[Status],
      [Transition].[Closed => Live]
    )>0
  ),
  [Time].CurrentMember.Name,
  ", "
)

Distinct Date
This measure will count the number of dates during which these transitions occurred.

Count(
  Filter(
    [Time].[Day].DateMembersBetween(
      [Sprint].CurrentHierarchyMember.Get('Start date'),
      CoalesceEmpty(
        [Sprint].CurrentHierarchyMember.Get('Complete date'),
        [Sprint].CurrentHierarchyMember.Get('End date')
      )
    ),
    (
      [Measures].[Transitions to status],
      [Transition Field].[Status],
      [Transition].[Closed => Live]
    )>0
  )
)

Use these measures together with the Sprint dimension members in Rows to see the respective numbers for each sprint.
​Best regards,
​Nauris

3

Thanks, @nauris.malitis .This works, but there’s one specific case it’s missing. Currently, it only captures in-sprint changes—meaning if a ticket is tagged to Sprint 1 and its status changes from “Closed” to “Live” within Sprint 1, it’s counted. However, I need to list all tickets within the project that had their status change from “Closed” to “Live” during the sprint, regardless of which sprint they are tagged to. For example, if a ticket belongs to a different sprint but its status changed from “closed” to “live” during Sprint 1, it should still be considered. How can I achieve this?