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

Questions & Answers
1

I want to get a calculation of the number of days that elapsed from the time issue was created until the issue enters a non-resolve status.

Example issue is created and is in status New.
Workflow of New --> In Progress --> Design Complete --> Design Review --> Design Approved --> Ops Review Needed --> Passed Ops --> Implemented --> Released --> Closed.

I want to to get a count of the days from New to Ops Review Needed.

Want to have it per issue instead of an average.

2

Anybody have any pointers on this?

3

There are several measures related to the [Transition]

TimestampToDate(
[Measures].[Transition from status first timestamp]
) might be able to be modified with a filter to get the status you need.

I know I’m not much help, but I am also frustrated by the lack of response on the board and I am hoping I can at least get you an idea to work from.

1 Like
4

That’s great Ed. I will try that and update here. It is kind of strange, cause the EazyBI team is very active. I know they are in the middle of a couple user events, which may be impacting the activity.

Thanks again.

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
6

Thank you! I am working on a solution combining your feedback.

7

Hi,

You could create a new calculated measure using this code:

Aggregate(
{
[Transition Status].[New],
[Transition Status].[In Progress],
[Transition Status].[Design Complete],
[Transition Status].[Design Review],
[Transition Status].[Design Approved]
},
[Measures].[Days in transition status]
)

It would calculate the total time in days for issue in source statuses

Martins / eazyBI support

1 Like