it’s probably a reoccurring question, but I didn’t found a solution that works for me in the already given answers.
I’d like to analyse our value stream, so that along our workflow I can set up a bar chart to compare the average time spend in our status at different timeframes (SaFe Program Increment and latest running 90 days). This would include all issues currently in a specific state and those that transitioned in the given time frames.
My current approach - which I know is incorrect - is the following:
NonZero( ([Measures].[Days in transition status], [Status].[Funnel]) + ([Measures].[Days in transition status], [Transition Status].[Funnel]) ) / NonZero( ([Measures].[Transitions to status issues count],[Status].[Funnel]) + ([Measures].[Transitions to status issues count],[Transition Status].[Funnel]) )
I’m new to eazyBI and this is with my current knowledge the closest I could get to - right now I see the following problems with this approach:
- Some results are infinite
- When an issue transitioned multiple times into the same state it is counted multiple times.
I did try Average days in transition status + average days in current status, but this approach didn’t work for me as Martins suggestion always returns an empty result.
Anyone who can support here? Thanks in advance - I appreciate it a lot.