Calculating Flagged Cycle Time in Days

[martins.vanags]

Hi,

You could explore these two use-cases described here:

Days since issue was flagged

@joejames Just thinkging, If you use “Time” dimension in your report to filter the report it would affect the result and filter only changes within the selected time period. Try this more universal formula: TimestampToDate( ([Measures].[Transition to last timestamp], [Transition Field].[Flagged], [Time].Currenthierarchy.DefaultMember ) ) And similarly, add [Time].Currenthierarchy.DefaultMember in your second formula Martins / eazyBI

Calculating Blocked time on Issues using Flagged Field

Guy, You need to create a new custom calculated field using the Javascript for the solution. These advanced settings create a new measure giving the number of days for the Impediment status for the completed cycles (when the Impediment flag was also removed from the issue): [jira.customfield_days_flagged] name = "Days Flagged Impediment" data_type="decimal" measure = true javascript_code=''' var date_from = Date.parse(issue.fields.created); var days_flagged = 0.0; issue.changelog.histories.f…

Martins / eazyBI