Hi,
The Javascript code gives value for issues having at least one transition to “Impediment” and transition from “Impediment.” The result will not be populated if the issue is for the first time marked as Impediment.
This thread discusses the approach for calculating the days since the last change in the Flagged field: How long Issue was flagged to Paused (Cumulative) - #6 by janis.plume.
The solution can be used to calculate the days since Flagged as Impediment for the issues currently Flagged.
The calculation of the days since the issue is moved to status should not need the Javascript calculated custom field. The most straightforward way to have the time in current status is:
CASE WHEN
[Measures].[Issue status]="Blocked"
THEN
DateDiffDays(
[Measures].[Issue status updated date],
Now()
)
END
Kindly,
Janis, eazyBI support