Custom field: Calculating days between creation and issue moved date

Mitesh Chauhan

Hi all,

I have a project where tickets will be moved from other projects. I would like to create a report in my project.

What I want to record or calculate for each ticket is:

When a ticket is move to my project - 

1. No of business days = Ticket Moved date - Ticket created date 

When I resolve a ticket

1. No of business days = Ticket Resolved date - Ticket Moved date 

I would like to apply this solution to all the tickets were retrospectively moved. Can someone guide me through the path to reach this?

Many thanks in advance

Mitesh

John Funk

Hi Mitesh,

Sure - You will need to create two new custom Number fields to store the different calculations. Make sure you name them something different from each other. 

Then create an automation rule to do the calculation of the differences in the dates. The rule will be based on a Field Value changing - like the dates used in the calculations. 

Then you have a new action for Edit Issue. Choose the number field(s) you want to update. Then you will use a formula to do the difference. Something like:

{{issue.customfield_16825.diff(now).days}}

You can use the custom field ID or the field name

like: {{issue.Ticket Moved Date.diff(now).days}}

Here is an example: