Discount transition time from subtask to parent

Questions & Answers
,
1

I have the following situation:

image

Is it possible that to the time of the Parent HU, the transition time of the subtasks is discounted, in order not to duplicate times associated to the development of an activity?

the formula I am using is:
([Measures].[Days in transition status],
[Transition Status.Category].[Listo]) +

([Measures].[Days in transition status],
[Transition Status.Category].[En curso])

2

Hi @Marco_Martinez ,
If you want only results from the “Standard” issue type, add the standard issue type member from the type hierarchy to your tuple: [Issue Type.By type].[Standard] or use sub-task type to see only results from sub-tasks: [Issue Type.By type].[Sub-Task]

The formula would be like this:

([Measures].[Days in transition status],
[Transition Status.Category].[Listo],
[Issue Type.By type].[Standard])
+
([Measures].[Days in transition status],
[Transition Status.Category].[En cursor],
[Issue Type.By type].[Standard])

best,
Gerda // support@eazybi.com