Could you please help me with a formula? I want to calculate the throughput of unique tasks per month

Questions & Answers
1

Good afternoon!

Could you please help me with a formula? I want to calculate the throughput of unique tasks per month. That is, how many tasks have moved from “To Do” to “In Progress,” how many of them then moved to the “Owner Check” status, and so on, as well as how many tasks remain in each status.

I need the count of unique tasks, not the number of transitions, to understand where tasks get stuck and where resources are lacking.
now i use
issue in status
NonZero(
Count(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
([Measures].[Transitions to status],
[Time].CurrentMember) > 0
)
)
)
from status
NonZero(
Count(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
([Measures].[Transitions from status], [Time].CurrentMember) > 0
AND

  ([Measures].[Transitions to status], [Time].CurrentMember) 
  <= ([Measures].[Transitions from status], [Time].CurrentMember)
)

)
)
But this calculation is incorrect when checking the actual tasks via “Go to source.”

2

Hi @Egor_Polevoy,

To calculate the throughput of unique tasks per month through different statuses, I recommend using the Transitions to status issues count measure, which counts unique issues that transitioned to a specific status.

Here’s a formula to count unique issues that moved from “To Do” to “In Progress”:

Tuple 1

(
[Measures].[Transitions to status issues count],
  [Transition].[To Do => In Progress]
)

To track how many of those issues then moved to “Owner Check”, you can use:

(
    [Measures].[Transitions to status issues count],
    [Transition].[To Do => In Progress],
    [Status].[Owner Check]
)

Alternatively, you can use the following formula to see if the issues that went from To do → In Progress then went to “Owner check” status:

Note: Tuple 1 is reference to the first formula I gave in this post. You will need to replace it with the name of your calculated measure accordingly.

Sum(
    Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
        [Measures].[Tuple 1] >0
    ),
    CASE WHEN 
    (
        [Measures].[Transtitions to status],
        [Transition Status].[Owner check]
    ) > 0
    THEN 1
    END    
)

I hope this helps.

Best,
Marita from support@eazybi.com