Jira automation for getting statistics

[lh_2023]

Use Case: I want to store weekly individual statistics (mostly of the type "number of issues in filter A" divided by "number of issues in filter B") and don't want to need any commercial plugins.

My idea: Create a JSW-project and a Jira Automation creating each week a new issue and store the number of issues in filter A in a custom field "numberA" and the number of issues in filter B in a custom field "numberB".

The problem: I can't find any chance to store the number of issues of a filter in a custom field using Jira automation!

Does anybody have an idea? 

[Evgenii · Accepted solution]

Hi, @lh_2023 

Yes, you can make it with Jira Automation.

For that you need to make a rule, which creates issues, and after this makes some JQL queries, results of which will be written in numeric custom fields.

You need to use smart value 

{{issues.size}}

Information about it can be found here:

https://confluence.atlassian.com/automation/jira-smart-values-issues-993924860.html

and here:

https://confluence.atlassian.com/automation/examples-of-using-math-expression-smart-values-993924632.html

[lh_2023]

Thanks for the quick response, I was getting so far. But what do you mean with "after this makes some JWL queries, results...". What type of rule action do I need for this? Do you have an example?

[Evgenii]

I made an example, hope it will help to understand, what I meant. I saved vaues to log, just to show you, how it's working. You'll need to save it to custom fields.

[lh_2023]

Ok yes thanks so far. But if I take the action "edit issue" instead of "Add value to the audit log", it will edit the issues found by the JQL, won't it?

Before the steps in your screenshot there is a step "create issue X" and I want to edit the custom fields in issue X with the smart values you explained. So how can I take the issue X instead of "Add value to the audit log"?

[Evgenii]

Well, there's one trick. In Cloud you can make variables, and use it.

In Jira DC automation can't make it :(

https://confluence.atlassian.com/automation074/working-with-related-issues-1141481085.html

Sorry, I missed, that you're using DC/Server version. 

[lh_2023]

Could one use project.properties for that?

[Evgenii]

Well, it's very weird way, but yes, you can.

[lh_2023]

thanks. Since I have a separate projects for the statistic issues I had to use the user.property. But hey - it worked!

[Evgenii]

It's great! As usual, crazy solutions work :)

If answer helped you, please accept it, it will mark question as resolved and it will help other people with similar questions

[Serosoft Jira Administrator]

Hi,

I can suggest these steps which involve no cost but by using Google Sheets:

1. Create two filters as required. 
2. Create a Google Sheet
3. Use an Extension "Jira Cloud for Sheets"
4. It can import the list of issues based on the filters created (or you can paste JQL there also)
5. A scheduler can be configured for an auto-update based on the required frequency. 
6. Once the issue list is available, you can use count, and other formulas to create a weekly statistics dashboard. 

See if it works for you. 

[lh_2023]

thanks, but I can't use any extension using data stored on a different server