Is it possible to show the amount of time tickets were flagged during Cycle Time?

I have setup a Cycle time chart using ‘Average Days’ from the Cycle measure. I would like to show the average amount of time in days the tickets were flagged during the Cycle time and represent it on the same chart as a stacked bar.

Is there a way I could add this?

Thanks

I’ve made a bit of progress, following the instructions from the thread here.

This is what I currently have:

Could someone please help me validate my understanding of the Measures?

  • Days of Resolved Issues: This is from the Cycle measures so I’m assuming this is the total number of days all tickets spent In Progress (the statuses I defined for the Cycle). Basically, total Cycle Time in days during this period?
  • ^^ I’m wondering what happens where the Cycle Time of a ticket crosses 2 quarters, is the time split between the two quarters, or only included in one of them?
  • Average Days Days of resolved issues divided by number of resolved issues?
  • Days Flagged Impediment resolved Total number of days resolved tickets were flagged (where the ticket is now unflagged)??
  • Days Flagged Impediment Created ???
  • Days Flagged Impediment Due ???
  • Days Flagged Impediment Closed ???
  • Days Flagged Impediment with due date Total number of days resolved tickets were flagged (where the ticket had a due date?)??

@janis.plume @ilze.leite Wondered if you could help me fill in the gaps and validate the above?

Thank you

Hello @pete1 ,
Measure < Cycle > days of resolved issues is linked to the Time dimension by the resolution date. It is the total number of days issues spent in any status of the cycle for completed cycles.
While Average < cycle > days on the Time dimension, is grouped by the last date when the issue moved from the cycle to any other not-cycle status.
You can read more about how cycle days are calculated and linked to time dimension in the documentation page: Issue cycles

And measures Days Flagged Impediment resolved/created/due/closed is linked by resolution, creation, due date, or closed at date. Read more about total number field measures here: Jira custom fields

Regarding your original question, you can select change history for the “Flagged” custom field:

Then, you can use the dimension “Flagged” with the “Transition status” dimension and measure “Days in transition” to see the combination of the flagged issues in particular statuses (or use the “Cycle” hierarchy from the “Transition status” to see the days split by cycles).

Kindly,
Gerda // support@eazybi.com

1 Like