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}}
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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: https://support.atlassian.com/jira-software-cloud/docs/automation-actions/#Automationactions-Lookupissues
There is at least one open suggestion to improve this, but it has moved to the dreaded Future Consideration status: https://jira.atlassian.com/browse/JRACLOUD-75018
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,
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Cheers,
Claire
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.