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; } } }

How to get the total number of tickets in a project

Krishtee_04ekg5

Hello,

I need to build an automation which:

1. For a specific project (XXXProject), calculates the total number of tickets whose status is in "Done" and having issue type "Epic".

What I got so far:

Once the automation is run, the value obatained should be displayed in the dashboard under column "Total Number Of Tickets" which is a number field:

But, when i'm running my automation, I'm not getting any values in the dashboard.

Can anyone advise what's wrong with my automation?

Thanks.

Accepted answers

Kseniia Trushnikova

{{issues.size}} can be used either with the trigger Incoming Webhook or the trigger Scheduled. Check out more info here in the documentation.

Here's the example of the rule:

Rule Example.png

All comments

Alisa Zamaraeva

Hi Krishtee,

To calculate the number of tickets you have to run a jql query inside the rule with lookup issues action and then use smart value {{lookupIssues.size}}.

You can see the example on my screenshot below:

Screenshot from 2023-08-11 15-10-07.png

Hope this helps!

Krishtee_04ekg5

Hi @Alisa Zamaraeva

Thanks for helping.

But I don't have the "lookup issue" feature available.

Can you please advise how to proceed?

Kseniia Trushnikova

{{issues.size}} can be used either with the trigger Incoming Webhook or the trigger Scheduled. Check out more info here in the documentation.

Here's the example of the rule:

Rule Example.png

Kseniia Trushnikova

@Alisa Zamaraeva, it looks like @Krishtee's using Jira Server/Data Center. Lookup issues is available only for Jira Cloud.

Good answer though!

Krishtee_04ekg5

Hi @Kseniia Trushnikova

Thanks.

I tried your solution.

It is displaying 1 for each tickets whose status is set to Done.

However, I need a calculation which will calculate the sum of all the tickets which have status Done.

For eg: If in a project I have 5 tickets and 3 out of it is in status Done, then the calcualtion should display 3 in the dashboard (column Total Number Of Tickets)

Kseniia Trushnikova

@Krishtee, my bad for not mentioning to select Process all issues produced by this trigger in bulk.

Try to run the rule once more with this option enabled:

Krishtee_04ekg5

@Kseniia Trushnikova

Thanks for the help.

It works as expected.

Hello Everyone,

I have a similar requirement. I need to get how many Tasks are in an Epic

We create Epics and each Epic has a number of Tasks. I'm looking to how many Tasks are open / closed.

I have tried the lookup feature but when I use issues.size it gives me the number of items in the query not the ones in the Epic

Any suggestions would be great

Welcome!

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

Quick Links

Find more posts tagged with

jira-service-desk-cloud

jira-service-management-cloud

jira-service-management