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 Jira Report on SLAs

Hi there, 


I am trying to create an automation for Jira that sends a Slack message to our team with data on the Average Hr amounts coming from our SLAs and Reports/Dashboards. 


Is there a way to query on the project to report out on these:

# of Open Tickets (current month): {{openTickets}}

# of Closed Tickets (current month): {{closedTickets}}

Average Time to Resolution in a given week: {{ttR}}

Average Time to First Response in a given week: {{ttfR}}

1 answer

0 votes

Hey there, so I'm able to use Lookup Issues and both the .sum and .average smart list commands for the values above. I am just wondering how I can use more than one smart value that equals lookupIssues.. And also if Time to first response will work for the custom field value. 

Thanks team!

Screen Shot 2021-07-14 at 3.15.07 PM.png

Hi @Claire Bilski 

I am unclear what you mean by "use more than one smart value that equals lookupIssues".  You can use the Lookup Issues actions, do what you need, and then use it again with a new query.

Unfortunately, Lookup Issues only supports a limited number of issue fields:

There is at least one open suggestion to improve this, but it has moved to the dreaded Future Consideration status:

Given these constraints, I suspect that if JSD doesn't have the reporting you need, you will need to investigate reporting outside of Jira or check the marketplace for addons, such as dashboard gadgets, JQL extensions, or other report addons.

Best regards,

Like Claire Bilski likes this

Thanks @Bill Sheboy , that helps a lot! 


The other problem I'm having with Lookup Issues is getting it to return more that 100 issues. 


Say ~340. 


Anyways, I'll checkout what's available in marketplace.



Yup, that 100 limit probably helps manage performance and leads to other issues.  One of the reasons I suggested checking on the dashboard is that some of the gadgets do not appear to be constrained by the 100 limit.

Suggest an answer

Log in or Sign up to answer
Site Admin
Community showcase
Published in Trello

🏊‍♀️ Atlympic Event: Trello

Hello Community!  Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...

169 views 2 13
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