# How to make Report using Time in Status (Lead Time & Cycle Time Distribution)

**URL:** <https://community.eazybi.com/t/how-to-make-report-using-time-in-status-lead-time-cycle-time-distribution/4204>\
**Category:** Questions & Answers\
**Created:** [April 18, 2020, 5:14am UTC](https://community.eazybi.com/t/how-to-make-report-using-time-in-status-lead-time-cycle-time-distribution/4204 "2020-04-18T05:14:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sinchan\_3188](https://community.eazybi.com/user_avatar/community.eazybi.com/sinchan_3188/32/2836_2.png) [@sinchan\_3188](https://community.eazybi.com/u/sinchan_3188)\
**Post date:** [April 18, 2020, 5:14am UTC](https://community.eazybi.com/t/how-to-make-report-using-time-in-status-lead-time-cycle-time-distribution/4204/1 "2020-04-18T05:14:01Z")

</div>

Hello guys,

I’m a newbie and unfortunately, I got a requirement from user to make these kinds of report :

 ![Lead Time Distribution](https://community.eazybi.com/uploads/default/original/2X/1/184f84fe624231aca60a66ca3218db16a5e8838c.jpeg)

Lead Time Distribution :  
X axis: days elapsed from open to closed  
Y axis: No of ticket  
Filter all closed “development” issues (closed in the past 90 days)

and

Cycle Time Distribution

X axis: days elapsed from in Progress to closed  
Y axis: No of ticket  
Filter all closed “development” issues (closed in the past 90 days)

I’ve tried to make the reports, but the results are still wrong ☹

Thanks for your help~

Regards,

Sindy

---

<div class="post-metadata">

**Author:** ![ilze.leite](https://community.eazybi.com/user_avatar/community.eazybi.com/ilze.leite/32/19_2.png) [@ilze.leite](https://community.eazybi.com/u/ilze.leite)\
**Post date:** [May 29, 2020, 11:17am UTC](https://community.eazybi.com/t/how-to-make-report-using-time-in-status-lead-time-cycle-time-distribution/4204/2 "2020-05-29T11:17:15Z")

</div>

Hi @sinchan_3188  
Welcome to the community!

You may want to start with [Resolution dimension](https://docs.eazybi.com/display/EAZYBI/Interval+dimensions) which shows the issue distribution by resolution time (from creation date to resolution date).

If this is not what you were looking for, you may use JavaScript calculated custom field to calculate lead time for each issue during data import. This field would contain a calculated number of days (lead time) between two dates (transition to In Progress and closing date) and would be imported with setting that allows to import this number as a interval dimension.  
Here is described a couple of examples how to do that (including needed advanced settings): [https://docs.eazybi.com/eazybijira/data-import/custom-fields/javascript-calculated-custom-fields#JavaScriptcalculatedcustomfields-Customcalculatedfieldasanintervaldimension](https://docs.eazybi.com/eazybijira/data-import/custom-fields/javascript-calculated-custom-fields#JavaScriptcalculatedcustomfields-Customcalculatedfieldasanintervaldimension)

After importing this interval dimension, in the report, you would use this interval dimension with a measure “Issues created”. Then issues would be counted to the correct interval accordingly to the calculated lead time.

Best,  
Ilze / [support@eazybi.com](mailto:support@eazybi.com)