Calculating Flagged Cycle Time in Days

[stephvaldo]

Hello,

My teams currently use the flagged option in Jira when a card is being blocked. We gather metrics in EazyBI at the end of each sprint. We currently are having trouble creating a report where we can calculate a cycle time of how long a card is being flagged for.

The idea would be to start counting the cycle time as soon as the card is flagged and then end when it’s unflagged.

Is this possible?

Thank you in advance!

[ZethA]

I’m having the same issue. We can build reports but because the flag in jira can be flipped off and on without impacting the ticket status, it is very hard to pin down how long it was "blocked and the status it was blocked in.

[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

[stephvaldo]

Thank you Martins! I think this is exactly what we were looking for!

[luvithomas]

Hello,
I thing you can start by creating custom fields in Jira to capture the timestamps when a card is flagged and unflagged. It ensure these custom fields are imported into EazyBI. EazyBI, create a calculated measure to compute the difference between the flagged and unflagged timestamps using the DateDiffDays function.