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

Christopher Bell
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 9, 2024

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.

 

2 answers

1 vote
John Price
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 9, 2024

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?


Valeriia_Havrylenko_SaaSJet
Atlassian Partner
September 12, 2024

.

0 votes
Valeriia_Havrylenko_SaaSJet
Atlassian Partner
September 12, 2024

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. 

image.png

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

image.png

 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 😊

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events