Calculate TAT for a work item

Question

Hi All,

I have created a field that captures actual start and end date of a work item, I would like to calculate TAT (Business Days) between these start and end date and store it in a TAT field using an automation and should be a read only field. Could you please suggest a way to do it

Bill Sheboy · Answer

Hi @Abhilash Tumbagonahalli Sriranga

What have you tried thus far to solve this?

If you have a rule that is not working as expected, please post images of your complete rule, the audit log details, and explain what is not working as expected.  Those will provide context for the community to offer better suggestions.

If you have not yet started a rule, you could use date / time functions to calculate the difference value: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#Date-difference---

To make a field read-only, that is normally done by adding it to the Create view but not the other ones: https://support.atlassian.com/jira/kb/how-to-make-a-field-read-only-in-jira-cloud/

But you instead want to set the value later, after the work item is created.  A couple of options are:

* Obscurity* Rather than using a custom field, use an entity property.  That will be reportable and more difficult to access for modification.

* Override the read-only / editability* Rather than using the built-in Edit Work Item action, call the REST API endpoint with the Send Web Request action to edit the work item, passing the parameter to overrideScreenSecurity

Kind regards,
Bill