Days Diff field

Questions & Answers
1

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.?

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