I have a bug board and i would like to calculate for each issue:
(Resolved issue time) - (created issue time) = XX d YY h ZZ s
I would like to apply this solution retroactively. Can someone guide me through the path to reach this?
Hi @Lucas Mucidas
Welcome to the community 🙂
Using automation it's easy to carry out these tasks
Please find the reference here
https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time
To get the time difference, here's the steps you need to follow
Create a text field to have difference data
Create a Automation and have issue transitioned to a status (status when issue is resolved) as the trigger
Edit the issue to include below value
{{issue.created.diff(now).days}}
You could include hours if it's convenient for you
This should have the value of difference of created and resolved date
Thanks,
Pramodh
Hi Lucas - Welcome to the Atlassian Community!
1. Create a custom number field to hold the value of the difference.
2. Create an Automation for Jira rule based on whatever trigger you want - probably when Issue transitione to Resolved.
3. Add a New action for Edit Issue to the rule to calculate the difference of the fields. Select the new number field. In the open space put this:
Or you can use minutes if you like.
Hey Lucas, welcome to the community!
I think you can use automation for Jira in this case.
https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#Example.2
Cheers,
Melo
FYI For reference
It worked like a charm your solutions
Thank you
For the sake of accuracy you could use this snippet in order to report business days only (also for the past):
{{issue.created.diff(issue.resolved).businessDays}}
It looks like you're new here. Sign in or register to get started.
