Days Diff field

Questions & Answers
2

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