# Cycle Time per Sprint

**URL:** <https://community.eazybi.com/t/cycle-time-per-sprint/8805>\
**Category:** Questions & Answers\
**Tags:** jira, sprint\
**Created:** [February 10, 2022, 11:09am UTC](https://community.eazybi.com/t/cycle-time-per-sprint/8805 "2022-02-10T11:09:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![hannah](https://community.eazybi.com/user_avatar/community.eazybi.com/hannah/32/6413_2.png) [@hannah](https://community.eazybi.com/u/hannah)\
**Post date:** [February 10, 2022, 11:09am UTC](https://community.eazybi.com/t/cycle-time-per-sprint/8805/1 "2022-02-10T11:09:11Z")

</div>

![Screenshot 2022-02-10 at 11.07.50](https://community.eazybi.com/uploads/default/original/2X/c/c6b84fd80734085e952058c8560f5a3abd8f7d91.png)

Hi,

I’m trying to create a graph to show the cycle time per sprint. I’ve followed [Control Chart - Lean Agile Tools](https://leanagiletools.com/control-chart/) and now have the cycle time per month (attached image), but am struggling to break it down to be per sprint?

Thanks

---

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [February 17, 2022, 9:47am UTC](https://community.eazybi.com/t/cycle-time-per-sprint/8805/2 "2022-02-17T09:47:25Z")

</div>

Hi @hannah

Try this demo report: [Control chart (Cycle Time) - Issues - Jira Demo - eazyBI](https://eazybi.com/accounts/1000/cubes/Issues/reports/146245-control-chart-cycle-time)  
You can remove “Time” dimension from rows, switch to “Line” chart view and use “Sprint” dimension in rows and expand to sprint-level members.

Note that you can use also one dimension both as rows and [pages](https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Pagedimensions).

Martins / eazyBI

---

<div class="post-metadata">

**Author:** ![Mauro\_Bennici](https://community.eazybi.com/user_avatar/community.eazybi.com/mauro_bennici/32/2043_2.png) [@Mauro\_Bennici](https://community.eazybi.com/u/Mauro_Bennici)\
**Post date:** [April 21, 2022, 8:28am UTC](https://community.eazybi.com/t/cycle-time-per-sprint/8805/3 "2022-04-21T08:28:46Z")

</div>

Hello @martins.vanags,  
following your instructions leads to a report where the average cycle time is blank, because it’s time bound.

```auto
AVG(
  {[Time].CurrentHierarchy.Level.CurrentDateMember.Lag(5):
   [Time].CurrentHierarchy.Level.CurrentDateMember},
  [Measures].[Rolling Average cycle time]
)

```

Is there a way to obtain a sprint-based average cycle time? I tried getting a time interval based on start and end date of current hierarchy member of the sprint dimension, but it doesn’t seem to work.  
regards.

---

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [April 25, 2022, 9:42am UTC](https://community.eazybi.com/t/cycle-time-per-sprint/8805/4 "2022-04-25T09:42:38Z")

</div>

@Mauro_Bennici

Try this formula:

```auto
AVG(
  {[Sprint].CurrentHierarchy.Level.CurrentMember.Lag(5):
   [Sprint].CurrentHierarchy.Level.CurrentMember},
  [Measures].[Rolling Average cycle time]
)

```

Note that LAG method would look for the 5th member before the current sprint (displayed in report rows) and they are ordered by Sprint IDs.

Martins / eazyBI support