nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Evgenii

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

All comments

Evgenii

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?

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

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-service-management

jira-service-management-server