Hi,
This Javascript is designed to track the days in Flagged status for the “completed cycles”. That means the days will be counted once the Flag is removed.
The calculation of the time for currently flagged issues will not be precise with the Javascript since the Javascript is executed during the data import. A solution to count the time in the currently flagged status could be calculated using the custom measure in the report.
For each issue, the following formula gives the date and time when the last transitions in the Flagged field happened:
TimestampToDate(
([Measures].[Transition to last timestamp],
[Transition Field].[Flagged])
)
If you know the issue is currently flagged, the following formula gives the days:
DateDiffDays(
TimestampToDate(
([Measures].[Transition to last timestamp],
[Transition Field].[Flagged])
),Now()
)
Kindly,
Janis, eazyBI support