Just a heads up: On March 24, 2025, starting at 4:30pm CDT / 19:30 UTC, the site will be undergoing scheduled maintenance for a few hours. During this time, the site might be unavailable for a short while. Thanks for your patience.

×
Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Auditing of due-date changes - Export to Power BI

Mark Morgan June 8, 2023

Hi,

Is it possible to retrieve the history of an issue's due date in order that the number of changes, and values can be exported for use in external reporting?

For example, if there are three issues being reported on, one has had no changes to the due date, one has had it changed once, one has had four changes. Can I export all the due dates ever assigned to these issues?

2 answers

3 votes
Liubov Topchyi
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.
June 12, 2023

Hello Mark @Mark Morgan ,

If you use Power BI, Power BI Connector for Jira can help you get the data you need.

How it works:

1. Install the app (it is available for a trial to explore whether the app works for you or not)

2. Create a data source by selecting the Histories table filtered by Due date:

due date.png

3. Export the data in Power BI: you can track the date of changes and old/new values for the due date

duedate.png

 

If you need our help on anything, please feel free to create a support request, and we'll be happy to help.

 

Regards,

Luba

Mark Morgan June 12, 2023

Thanks Luba, I'll check this out.

Like Liubov Topchyi likes this
3 votes
Yuliia_Borivets__SaaSJet_
Atlassian Partner
June 9, 2023

Hi @Mark Morgan 

Have nothing in mind from the built-in options. If you are ok with plugins, I would like to suggest Issue History for Jira from my team. Here, you can add the due date field as a column and get all changes for the list of issues. You can filter issues by project, sprint, dates, etc. Export to SCV, Excel is also available.

You can also choose only specific issues if you know their issue keys.

Due date history.png

You can try the app for free for 30 days. Let me know if it fits your case or if you have any questions.

Mark Morgan June 12, 2023

Thanks for the suggestion Yuliia.

Suggest an answer

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

Atlassian Community Events