I need to create a report that shows the delta between various date and time fields.

Question

we have workflows  created in Jira  that include a number of date/time fields. - planned start  actual start etc. I need to generate a set of reports showing  any delta between the planned start date for a task and the actual start date, planned completion - actual completion - what is the easiest way to acheive this.

Valeriia_Havrylenko_SaaSJet · Answer

Hi @Christopher Bell  👋 
Welcome to the community!

For your needs I would recommend trying out our another add-on Time Metrics Tracker. The add-on is specifically designed to get a report that shows the delta between various date and time fields.

You can also set up highlights of values that exceed the permissible level, and in this case, you can receive issue and email notifications.

Benefits:

* Identify Bottlenecks: Quickly see where issues are getting stuck in your workflow.
* Optimize Processes: Use data to streamline processes and improve efficiency.
* Enhanced Reporting: Gain deeper insights into your team's performance and workflow effectiveness.
* Improve Accountability: Make data-driven decisions to hold teams accountable and drive continuous improvement.

Add-on is free up to the 10 users and developed by my SaaSJet team.

I hope this helps 😊

Valeriia_Havrylenko_SaaSJet · Answer

.

John Price_q5a7ni · Answer

Hi -

I don't think there's a straightforward way to do this without automation or a 3rd party app like eazyBI (see https://community.atlassian.com/t5/DevOps-questions/JIRA-reporting-Planned-start-date-Vs-Actual-start-date/qaq-p/1885789). With Jira Automation you could create a numeric custom field and use automation to populate it (something like

{{ActualStartDate.diff(PlannedStartDate).days}} days

There are built-in reports in different project types (burndown, cycle time, etc.) but I don't think you can report on exactly what you want. In JSM projects you can set up SLAs and track adherence to those, which is the same idea as what you want.

Someone else may have a better answer.

At a higher level, you can look at why you are measuring this particular thing; there may be better ways to report on progress. That is, what is the business goal of knowing the delay amount?