Cycle Time Average per month

Questions & Answers
,
1

Hello, I’m trying to show a chart showing average Cycle Time per month or per quarter, over time with a trend line.

Would it be possible to create a calculated member to calculate for example:

  • For all Issues Resolved in the time period
  • Show average number of days a ticket spent in progress from one status to another (E,g from when it leaves ‘To Do’ to when it arrives in ‘Sign-Off’

I’m also looking to calculate the average amount of time resolved tickets were flagged during the time period (as a separate measure)

Thanks

2

Hi @pete1

Welcome to the eazyBI community!

You may want to define use Issue Cycles: read here: Issue cycles

In import options, define all the statuses in the cycle, then import data and use standard measure
“Average days” together with the Time dimension (months or quarters) in the report.
Add a “Resolution” dimension in Pages to filter issues who has a valid resolution set.

About flagged time: read another thread in this community, there is a solution how to calculate flagged time using JavaScript code: Calculating Blocked time on Issues using Flagged Field

Best,
IlzeLA, support@eazybi.com

3

Hi Ilze,

Thank you for the help. I managed to do the Cycle Time part using Issue Cycles and setting this up for the specific project.

Now I want to get the blocked time part working so I will have a read of that thread.

Thanks again

Pete