Creating a SLA based on the the time/date issue entered status A and entered status D

Questions & Answers
5

I wanted to do something similar. It’s not an elegant solution, but it’s what I came up with.

In the “Transition Status” section, I created a calculated member with the statuses that I wanted to be included:

Aggregate({ [Transition Status].[Dev Complete] , 
[Transition Status].[In QA], 
[Transition Status].[Deployment Pending]})

Then I set things up as follows:

  • Pages: Transition Status (select the new calculated member)
  • Rows: Time
  • Measures: in the predefined section, “Average workdays in transition status”

It isn’t the individual issue, but one can drill through.

Another possibly helpful tidbit lives over here: How to calculate Days in transition status including the time in current status

~ v.

2 Likes