Automation for total estimates

[Daniel Jones]

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
FROM
Open
TO
Pending

Then Send Email:

To Reporter

Subject
Request {{issue.key}} has been updated

Content
Hi {{reporter.displayName}}

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

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

Kind Regards,
{{assignee.displayName}}

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

[Earl McCutcheon]

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:

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:

• https://community.atlassian.com/t5/Jira-questions/How-to-generate-and-send-report-from-dashboard-data-on-schedule/qaq-p/421677

Regards,
Earl