Issue Status history based on the release dates

Basically I am looking for a chart which will show me the status of an issue in the release from the release/version start date till today. If possible, would like to see the sprint numbers on X axis either on top or bottom, so that I can show that the issue has been moving from sprint to sprint.

Hi @Daniel_Luevano,

As a start, I recommend the Version issues guideline report from our Demo account - Version Issues Guideline - Issues - Jira Demo - eazyBI. It uses the “Time within version” measure to filter the Time dimension by the currently selected version start and end dates.

You can replace the measures used in it with the measure “Issues history” and drill into the Transition Status dimension, to see the changes through status.

To see the Sprint dates, you can define a calculated measure with the formula below:

NonEmptyString(Generate(Filter( 
    [Sprint].[Sprint].Members,
  DateInPeriod(
    [Sprint].CurrentMember.getDate('End date'),
    [Time].CurrentHierarchyMember
  ) AND
    -- Sprint has issues with this version:
    ([Measures].[Issues history],
    [Time].CurrentHierarchy.DefaultMember,
    [Transition Status].CurrentHierarchy.DefaultMember) > 0),
    [Sprint].CurrentMember.Name,
  ', '
))

The report then could look similar to the one below:

Best,
Roberts // support@eazybi.com

Hi Roberts,
Thank you for your reply.
I tried to use the ‘Sprint end dates’ measure without the Version just to verify that it was showing all the Sprints, but it is showing only one Sprint on the Issue:

As you can see, the Issue is related with many Sprints:

Any ideas how to show all the Sprints by Issue to use it in the intended way?

Hi @Daniel_Luevano,

With a specific issue selected, you will see only the last Sprint because for earlier Sprints, the value for the measure “Issues history” will be zero as the issue has transitioned out of them. See the picture below:

I recommend using the suggested approach and drilling through issues for every Sprint end date to verify the correct issues appear.

Best,
Roberts // support@eazybi.com

1 Like