[JIRA]: How to get count of bugs that got reopened

[SergioHB]

Hi all,

I'm working on a Service Desk dashboard and trying to generate quality KPI for my team. At the moment, I need to know How many bugs got re-opened (transition from Closed to InProgress). 

Basically, I just want to store in a custom field the number of times certain transition is executed. (not just to measure total number of cases reopened but also number of times one case has been reopened) so I'd say, that field has to increase by 1 everytime a ticket is transitioned.

I'm pulling data from Jira Service Desk (Service Project) and that is coming on a similar presentation:

Whats the best way to acheive this?

Thank you in advance for your help.

Sergio

[SergioHB]

Hi @Anonymous 

Thanks for this, I'd say it works for counting on a request. But what if want to measure also the Total Number of Reopened cases? Using the same data I provided, we agreed on how many times each request was reopened but then need to measure by cases.

Does this makes sense to you?

Thnks

[Anonymous · Accepted solution]

Hi @SergioHB ,

Add measures like below:

case_closed_once = 
VAR _number =
    IF ( [REOPENED] > 0, 1, 0 )
VAR _closed =
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Request] ),
        FILTER ( 'Table', _number = 0 )
    )
RETURN
    _closed

count_no_reopended = 
SUMX ( VALUES ( 'Table'[Request] ), [case_closed_once] )

Total Cases Reopended = 
VAR _all = DISTINCTCOUNT('Table'[Request])
RETURN
_all-[count_no_reopended]

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @SergioHB ,

You can add a measure like below:

REOPENED =
CALCULATE (
    COUNTROWS (
        FILTER ( 'Table', 'Table'[Request] = SELECTEDVALUE ( 'Table'[Request] ) )
    ),
    'Table'[Status] = "Closed"
) - 1

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.