Need to send weekly status report with counts.

[Neeraj Pandey]

Hi All,

I wan to sent a weekly status report every Friday at 7 PM, How to do that?

I want my report to look like this , it can be html or text format:

Weekly Issue Counts:
- Reported Issues:
- Closed Issues:
- Moved to In QA:
- Moved to Dev:

This has a count of any issue reported, closed, moved to dev or qa in this week  only. 

I tried but failed.

Had created 4 filter and then used them in rule.

Weekly Issue Counts: - Reported Issues: {{filter("Weekly Reported Issue").count()}} - Closed Issues: {{filter("Weekly Closed Issue").size()}} - Moved to In QA: {{filter("Weekly In QA Issue").size()}} - Moved to Dev: {{filter("Weekly In Development Issue").count()}}

[David Freitez · Accepted solution]

Hi @Neeraj Pandey ,

There are several components to use in this automation that I can see:

• Schedule trigger to make it execute on everyday Friday at 7pm
• Lookup Issues to get the values of the JQLs you want.
  • For every JQL: 
    • Create lookupIssue
    • Store {{lookupIssues.size()}}  into a Variable (such as: ReportedIssuesCount)
• Create an email and use the Variables you created previously.

Please note that lookup will search up to 100 issues using a JQL query (Doc)

Have you tried the way I am proposing?,  what errors do you have now?

Regards,
David

[David Freitez]

Hi @Neeraj Pandey 

Were you able to tried they way I proposed?, kindly consider to mark my answer as accepted if it was helpful to contribute to your problem being solved.

Regards,
David

[Danut M _StonikByte_]

Hi @Neeraj Pandey,

One option would be to create a dashboard in Jira with the necessary gadgets on it, and use it as a report.

You could use the Filters Count gadget of Jira to display these numbers. All you need is to configure the gadget with custom counts and filters that return the issues for every count you need. 

 

If this gadget is not available in your Jira instance, you could search on Atlassian Marketplace for a similar gadget. A good option in this case is the Advanced Issue Filter Formula gadget offered by our Great Gadgets app, which supports not only counts but also sum of a field, average, percentages. Read more about it here: An effective dashboard for Service Desk and Customer Support teams in Jira Service Management 

Danut.