Geting the US complete date even when it was not in the selected sprint

Questions & Answers
, , , ,
1

Hi,

I am trying to report the cycle time report and get the start of In-progress status and the completion date of User stories that exist on the selected sprint.
The problem is some of the USs are not started in the selected sprint and some of them are not completed in the selected sprint.

can you help me to define that measures ?

I used the following formula :

DateParse((
  [Transition Status].[In Progress],
  [Measures].[Transition to status first date]
))
&
DateParse((
  [Transition Status.By name].[Completed],
  [Measures].[Transition to status first date]
))

and the result :

Screenshot from 2024-05-26 12-08-16
Screenshot from 2024-05-26 12-08-161395×498 246 KB

Thanks in advance

2

Hi @Ahmed_Shehata,

You can try to view the relevant issues by adding the measure “Issues history” to the report. It will return a value 1 or 0 if any issue was part of it. 0 will be returned for issues that are no longer part of the Sprint.

You can then filter the report rows by this measure to be >=0 and turn off the “Nonempty” option in the report rows.

Best,
Roberts // support@eazybi.com