how to calculate time spent during the multiple statuses through automation

Hello @Anser Ghazzaal Ali 

Calculating time spent across multiple statuses and triggering actions based on that data isn't possible with native Jira automation alone, but it becomes straightforward with Timepiece - Time in Status for Jira.

If you are open to using a Marketplace app, you can achieve this using Timepiece's Duration Between Statuses report combined with Jira Automation. This report type lets you define a metric that measures the total time an issue spent traveling through multiple statuses — for example, from "In Progress" to "Resolved" — and then use that data directly inside your automation flow to post comments, update fields, or trigger transitions.

1. First, you need to create a Cycle Time metric within the app.

2. In the report, you will see the calculated results based on the statuses you selected for that metric.

3. Create an automation and add Timepiece to the automation.

4. The automation will run when the defined conditions are met and will post a comment, just like in the example I showed.

You can find detailed instructions on how to create an automation in Atlassian's Getting Started with Jira Automation article.

Additionally, you can access our documentation, which includes a comprehensive collection of automation use cases and guides.

You can find Timepiece - Time in Status for Jira on the Atlassian Marketplace. After installation, reports can be generated instantly based on your existing issue history.

Full disclosure, I'm on the team that makes Timepiece. Hope this helps!

Best Regards,

Melisa Mutlu

Hi @Anser Ghazzaal Ali 

Short answer: Would you please explain what outcome you are trying to achieve with these measures?  What would your team do differently if you had that information right now?  Knowing those answers will help the community provide better suggestions.

Until we know that...

Other than for a very simple workflow (e.g., Todo, In Progress, and Done), measuring time-in-status with automation rules can be challenging.  This why marketplace vendors are suggesting products to you: their products can get the data from the work item changelog / history and process it with app code more easily than a rule or built-in Jira features can.

How do you want the time measures provided: a chart, number values, etc.?

• For a chart, you could try the built-in, Atlassian interpretation of a Control Chart under reports from the board...without the need for any automation rules.  This chart has some configuration options, although it also has several limitations.  To learn more, please look here: https://support.atlassian.com/jira-software-cloud/docs/view-and-understand-the-control-chart/
• For number values, multiple custom fields and automation rules would be needed to capture the start, stop, and difference times for each desired status.  That is a brittle, and challenging solution because:
  • Getting the data directly from the changelog / history is very challenging in a rule due to REST API responses / paging, and the filtering needed.  As an alternative rule structure...
  • Multiple rules are needed for the various possible ways status can change
  • Custom fields could be tampered with by people, and thus more rules are needed to manage that
  • Workflows and board configurations could change independently of the rules, leading to mismatch problems
  • Rules can stop running for various reasons, creating gaps in the time captures
  • And...once you have any number values, your team would need to decide how to use them: export the fields, report them with dashboard gadgets, etc.
  • All of which will require extensive testing and maintenance to keep the rules running

Kind regards,
Bill

Dear @Anser Ghazzaal Ali 

I you need to get the time each work item remains in each status you can use the SLA report of the Gadget Utilities for Jira Cloud

You can select the filter of work items to display and add the statuses you can track

Hi @Anser Ghazzaal Ali ! You can actually handle this with our app Time Metrics Tracker | Time Between Statuses 

It lets you calculate time spent in any status or between multiple statuses, and you can fully customize the metrics to match your workflow (cycle time, waiting time, time between specific steps — whatever you need).

On top of that, you get solid visualization tools like scatter plots, WIP charts, and trend gadgets to really understand what’s going on in your process — plus alerting if things start taking too long.

Also, it includes Manage Work Schedule, so your calculations can take into account working hours, weekends, and holidays, which makes a big difference if you want accurate numbers.

Happy to share more details if you’re exploring options 🙂