Hi everybody!
I’m new at eazyBI and I’m trying to create a report with some statistics about my projects:
How could I calculate a measure to get the difference between this dates when an epic starts first time to status “Analysing” and finish in status “Deployed” (or now() if it doesn’t have this status yet)?
Thank you!
Hi! I found something similar that I could use:
Avg(
Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
[Measures].[Issues created]>0
),
DateDiffDays(
([Measures].[Transition to status first date],
[Transition Status].[Analysing],
[Time].CurrentHierarchy.DefaultMember),
([Measures].[Transition to status last date],
[Transition Status].[Deployed],
[Time].CurrentHierarchy.DefaultMember)
)
)
1 Like