Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Automation for total estimates

Hi Guys

I would like to know if there's a way of adding up all the Estimated time on issues which fall into a certain category, and emailing that out as an automation

Here's an example of what I currently have

When: Issue transitioned

Then Send Email:

To Reporter

Request {{issue.key}} has been updated

Hi {{reporter.displayName}}

Your request is now in the queue: {{issue.summary}}.

Estimated time for this request is {{issue.timetracking.remainingEstimate}}

Kind Regards,


I would like to add in a line 'Estimated time in queue:' after estimated time for this request


1 answer

0 votes

Hello @Daniel Jones ,

Thanks for reaching out and one of the biggest blockers I can see for this is that the data pull for the smart value is coming from the individual issue, so you would need to first set up a method to sum up all issues from all issues assigned to the user into each individual issues to have a value to pull from and any options I can think of using Automation rules would be highly complex and add in a lot of overhead with a lot of potential failure points depending on user inputs, or change events such as re-assigning an issue to another user.

First off I would recommend taking a different approach and either using the email to redirect the user to view a dashboard using a Workload piechart or using some third-party tools to send out an email if the email notification is a critical point for your solution.

For the first point, I recommend using a dedicated reporting tool as automation tasks are designed around reducing inputs rather than aggregating outputs for reporting structures.

There are a lot of third-party tools that could give details user time tracking reports, but a natively available option would be using a workload piechart on a dashboard, and this option sounds like the best fit for your use case, and you can add a hyperlink to your automated message to inform the user to review the dashboard for the information surrounding the total load to their backlog, You could create a saved filter of "assignee = currentUser()" with any additional constraints you needed such as "AND resolution is EMPTY" to only include open requests if desired.  Then using that filter configure the workload pie chart for the Statistic and estimations you would like to see, something like the following seems like it would line up with your request:

  • Statistic type: "Status"
  • Time field to report on: "Current Estimate"

And would display the data like the following example for each individual user viewing the board noting the total time estimate is included at the bottom of the gadget:

Screen Shot 2021-04-12 at 1.11.00 PM.png

The follow up to this is that if you did require an email option of the dashboard there is not currently a native option to systematically generate a report from a dashboard so third party tools would be needed, and there is a good write up with an example in the following thread of how you could accomplish this using an alternate tool in conjunction with Automation for Jira for the trigger events:


Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Service Management

JSM Jira Automation: How to Send SLA Breached Notifications

Hi Everyone, In   this tutorial,  we will show you how you can monitor an SLA, and send notifications before or after the SLA has been breached.   SLA Threshold Trigger The SLA t...

633 views 5 12
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you