What is the correct smart value approach to calculate and format total active time excluding On Hold

[BAL GOVIND YADAV]

Hi Team,

I was working on the use case: Calculate the bug Resolution time,

here it was calculating the time from, issue creation to completion, and it was working fine.

Now I have another use case: for suppose if the issue is kept on HOLD it should stop calculating time when it is ON HOLD and resume when moved to other status and needs to display total time excluding that on hold duration time.

I tried create automation rule and execute but not getting expected result.
Kindly help on it.

Best regards,

Bal Govind Yadav

[Trudy Claspill]

Hello @BAL GOVIND YADAV 

Welcome to the Atlassian community.

To help you debug the automation rule please provide the following information:

1. Images showing your entire automation rule.
2. Images showing the details of any step where the full details are not seen in the step bubble in the diagram.
3. Images showing the output for the rule execution from the audit log for a run that did not give you the results you expected. Click the ">" icons next to each message to expand all the details.
4. An explanation of what results you expected versus the actual results you got.