Calculation between Actual start date and Actual end date in Jira

[omar.wehbe]

Greetings Atlassian Community, 

I have 2 questions: 

1. Is there a gadget that I am missing in the dashboard (a default one) that will make the calculation automatically between the Actual Start date and Actual End date fields in Jira tickets on a certain board? The project cycle duration does the calculation between the ticket created and status change which is something i do not want to do.

2. I am currently exporting my tickets to Google sheet and add a formula that does the calculation between the Actual start date and actual end date of the projects and it returns the number of days.

Is there an automation I can do to make my life easier where i can calculation that difference in Jira itself? 

[Dexter de Vera]

Hi @omar.wehbe ,

You can create automation to calculate the range.

Requirement field type:

Actual Start date - datetime field

Actual End date - datetime field

Create new field -Total (Name it) - number field

Create an Automation:

Trigger: issue updated - Actual Start date, Actual End date

Action: edit field - Total (Name it) 

Put this smart value: {{issue.Actual End date.diff(issue.Actual Start date).days}}

You can chance the smart value(days) base on weeks, hours, minutes etc.

Hope it helps

[Dexter de Vera]

{{issue.Actual End date.diff(issue.Actual Start date).days}}

[Thomas Runchina]

How would it look like, if I want the days on weekend excluded and instead of days in hours?

[omar.wehbe]

i DOubt this is correct. there shouldnt be any spaces. can you please assist ?

[omar.wehbe]

thanks a lot !