How do you create report for when a status was in a certain state

Questions & Answers
1

Hi,

I am trying to build a report from jira to show me how many tickets were in a certain status last month and are still unresolved. All I can get is the current status of the ticket to be pulled in.

2

I worked on a similar report. You can use this calculated measure:

Cache(
Count(
    Filter(
        Descendants([Issue].CurrentMember, [Issue].[Issue]),
        ([Measures].[Issues resolved], [Transition Status].CurrentHierarchy.DefaultMember) > 0
        AND [Measures].[Days in transition status] > 0
    )
)
)

Put the [Transition Status] dimension into Pages and the [Measures] dimension into columns. The [Time] dimension can go into Pages as well if you’re trying to filter easily. Not sure what you would put in rows necessarily, but that’s up to you.

That custom calculated measure up above would go into [Measures]. It says return all issues that transitioned into one of the selected transition statuses (from pages) over the past month. You can then put status dimension into pages as well, or add it as a filter in the calculated measure to only show items that are not done.

[Measures].[Issue status] != “Done”

Perhaps the issue dimension in Rows? Depends on what else you’re trying to show.

Give that a whirl, hope it helps.

– Malik Graves-Pryor

1 Like