I am currently trying to create a report showing the work item age (items that are in the “In Progress” status category) in a first step.
Issue cycles are activated for the “In Progress” status category.
As you can see the fields which should be filled using Issue cycles are empty, like “Issue Progress days”, Average Progress days" etc.
Additionally my calculated fields are not working as well, even if I can see the values from the fields I use in the report (see below)
Below you find my two tests on calculating the work item age:
The Issue cycle measures represent the duration of the cycle only for issues that have exited the cycle. Your solution it correct, to see the duration for ongoing cycles.
CASE WHEN --current Progress cycle has not ended, date property is empty
IsEmpty([Measures].[Issue Progress end date])
THEN --calculate duration based on start date
DateDiffDays(
[Measures].[Issue Progress start date],
Now()
)
END
--set measure formatting to decimal
