Calculated member for tickets that have transitioned from one status to another

[Melissa Martin]

I am looking to make a Measure calculated member which would calculate:

• Total # of tickets that transitioned from status "Waiting on Approver" to "Approved"
• Total # of tickets that transitioned from status "Waiting on Approver" to "Resolved"

These would be used as the columns with rows being "Transition Author". Using "[

I realize there is the Transition Dimension I could use, however I am also want to have columns for SLA % Met in the same report, so need these as a calculated member so I can have:

• Column A: Transition author name
• Column B: Total # of tickets they transitioned from status "Waiting on Approver" to "Approved"
• Column C: Total # of tickets they transitioned from status "Waiting on Approver" to "Resolved"
• Column D: Time in Open SLA % Met

[Petter Gonçalves · Accepted solution]

Hello Melissa,

I think that something similar to the functionality you want can be achieved by using the Two dimensional Filter Statistics gadget native of JIRA, however, I didn't find a way to return the % of tickets that breached/not breached the SL, Instead, It can be displayed in number.

These would be the steps:

1 - Create three new List custom fields: 

   # Final status: This field should be filled through post function once the issue moves from Waiting on Approver. It should receive Approved if the transition goes to Approved and Resolved if the issue is transitioned to Resolved.

   # SLA breached: This field should be filled through Automation rule once the issue is resolved. It should receive Breached if the Open SLA is breached or Not breached if the SLA is not breached.

    # User which performed the transition: This field should be filled through post function once the issue is resolved. It should receive the current user that performed one of the transitions.

2 - Bulk add the custom fields to your issues, selecting the correct values to it

3 - Create two filters:

    # One to return the issues that were transitioned from waiting on Approver to Approved 

Final status = Approved

    # Another to return the issues that were transitioned from waiting on Approver to Resolved

Final status = Resolved

4 - Navigate to your dashboard and add two Two dimensional Filter Statistics gadgets, selecting the respective Filters and the YAxis field with the User which performed the transition and the XAxis with the SLA breached field.

The gadgets will be displayed like below. P.S: I used the assignee and Issue type filter as the X-Axis and Y-axis since I don't have the suggested custom fields.

Let me know if this information helps.