Hi @uvis.lapsins
Thanks for the follow up!
I was actually trying to find out if there can be statuses in the middle between the Approved Estimate and the Approved.
This is the workflow you shared
New→Open→multiple_others→RequestEstimate→ApproveEstimate→Approved→In Implementation→Ready for Deliver→IT testing→Business Testing→Accepted→Billed→Closed (Resolution added)→Reopened (very rarely)
But can there be workflows as followijg?
New→Open→multiple_others→RequestEstimate→ApproveEstimate→ApproveEstimate→Open→Approved→In Implementation→Ready for Deliver→IT testing→Business Testing→Accepted→Billed→Closed (Resolution added)→Reopened (very rarely)
The reason I ask is to understand if we can filter out the set of Issues using the Transition dimension to only consider issues with a specific/strict transition.
Like in the screenshot below. When filtering 2025 and using the measure Transitions to status issues count and having the Transition dimension in Rows, I can see how many distinct issues had this particular transition in the selected time.
In your case you do not have this check. You are looking for issues that have had an Approved status, and then you are looking for the day difference between when the issue exited the Approve estimate status the first time (regardless of which status it proceeded to move further).
Also, I noticed a potential logic issue in your measure. You’re using:
'Transition from status first date' for Approve Estimate (when issue EXITED this status)'Transition to status last date' for Approved (when issue ENTERED this status)
If the transition is direct (Approve Estimate → Approved), these timestamps would be identical, resulting in 0 days difference.
(
[Measures].[Transition from status first date],
[Transition Status].[Approve Estimate],
[Time].CurrentHierarchy.DefaultMember
),
(
[Measures].[Transition to status last date],
[Transition Status].[Approved],
[Time].CurrentHierarchy.DefaultMember
)
If you are searching for this specific transition, you may try the expression below. I have changed the Transition from status first date to Transition to status first date to capture the date when it moved to “Approve Estimate”
Avg(
Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),
([Measures].[Transitions to status issues count],
[Transition].[Approve Estimate => Approved],
[Time].CurrentHierarchyMember
) >0
),
DateDiffWorkDays(
(
[Measures].[Transition to status first date],
[Transition Status].[Approve Estimate],
[Time].CurrentHierarchy.DefaultMember
),
(
[Measures].[Transition to status last date],
[Transition Status].[Approved],
[Time].CurrentHierarchy.DefaultMember
)
)
)
If you confirm that there CAN be intermediate statuses, use your initial formula instead, but amend the part where you check whether it moves from the status or to the status.
If this still does not resolve your problem, please reach out to us directly at support@eazybi.com, referring to this Community post.
Best,
Elita from support@eazybi.com
