Hi Team,
I need to select some fields if ageing >45 days (Incident report date to Implementation date.)
Hi,
The exact solution depends on the report outlook.
This community post describes how to calculate the time difference between two status transitions per issue:
Hi,
The DateDiffDays function can use tuples to find the time between two transitions:
DateDiffDays(
([Measures].[Transition to status first date],
[Transition Status].[In Progress]),
([Measures].[Transition to status last date],
[Transition Status].[Done])
)
This formula for an issue finds the days between the first transition to the In Progress till the last time issue transitioned to Done.
Kindly,
Janis, eazyBI support
Kindly,
Janis, eazyBI support