Days Diff field

I need some help on Days Diff, as i want to know time taken between 2 transitions. Can you please help on how to write query.?


The DateDiffDays function can use tuples to find the time between two transitions:

  ([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.

Janis, eazyBI support