Time in status for previous status

Questions & Answers
1

I want to get the time in source for an issue from the previous status of the current status. Since the current status is constantly changing, it is difficult to obtain time by defining it as a specific transition. Is there any way?

2

Hi @holtzman,

The following formula would give you the total days the issue has spent in the previous status (you probably would like to set the formatting to decimal):

(Filter(
  [Transition Status].[Transition Status].Members,
    ([Measures].[Transition from status last timestamp],
     [Time].CurrentHierarchy.DefaultMember)=
    ([Measures].[Transition to status last timestamp],
     [Time].CurrentHierarchy.DefaultMember,
     [Transition Status].DefaultMember)
).Item(0), [Measures].[Days in transition status])

Just in case, here is a formula that would return what the previous status was:

Filter(
  [Transition Status].[Transition Status].Members,
    ([Measures].[Transition from status last timestamp],
     [Time].CurrentHierarchy.DefaultMember)=
    ([Measures].[Transition to status last timestamp],
     [Time].CurrentHierarchy.DefaultMember,
     [Transition Status].DefaultMember)
).Item(0).Name

Lauma / support@eazybi.com

1 Like
3

@lauma.cirule Is it possible to obtain the status of a ticket on a given day? having in the columns time and sprint and the column some measure?