Issue cycle standard deviation calculation

Questions & Answers
1

Hi There,
I would like to calculate the standard deviation of issue cycles (we have ‘new’, ‘active’ and ‘waiting’ mapped) and plot on a time series chart. I would use this to show the +2 and -2 95% bands around the precalculated mean.

I could really use some guidance please

Thanks!

2

Hi @mfagan

Please check this presentation slides deck:
https://community.eazybi.com/uploads/short-url/5HVBHIyDYPGfdwQVjeLACrCkMkI.pdf?_gl=1*1rsfw18*_ga*MTMwNzMzNDczNC4xNjg3MTUzNDE0*_ga_LKTNY5C56W*MTY4OTkxNzIzMS4xMDUuMS4xNjg5OTIwMzgzLjYwLjAuMA.

In slide 19 there is very similar formula example described, just with +3 and -3

Martins / eazyBI

3

Thank you. That worked for me.

4

Hi,
how do I change the formula if I want to create a deviation for an average cycle time which goes as follows:
CASE WHEN
[Measures].[Issues resolved]>0
THEN
[Measures].[Progress days of resolved issues]
/
[Measures].[Issues resolved]
END

5

Hi @Agnieszka_Kochman

Try creating calcualted measure using this formula:

CASE WHEN
[Measures].[Issues resolved]>0
THEN
StDev(
Filter(
DescendantsSet([Issue].CurrentMember,[Issue].[Issue]),
DateInPeriod(
  [Measures].[Issue resolution date],
  [Time].CurrentHierarchyMember
)
AND
[Measures].[Issues resolved]>0
),
[Measures].[Progress days of resolved issues]
)

END

Martins / eazyBI