Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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
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

 

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:

Regards,
Earl

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
Community showcase
Published in Jira Service Management

ThinkTilt is joining the Atlassian Family!

This morning, Atlassian announced the acquisition of ThinkTilt , the maker of ProForma, a no-code/low code form builder with 700+ customers worldwide. ThinkTilt helps IT empower any team in their or...

852 views 30 33
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