How to get the total number of tickets in a project

[Krishtee]

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.

[Kseniia Trushnikova · Accepted solution]

Hi @Krishtee,

{{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:

[Krishtee]

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]

@Kseniia Trushnikova

Thanks for the help.

It works as expected.

[Krishtee]

Hi @Kseniia Trushnikova

I have a custom field "Lead time", where i'm calculating the difference between field Created and Updated.

Please find below my automation:

This rule works correctly and is outputting the result in my dashboard:

Next, I want to calculate the sum of all the values from field Lead time. For that, I have created another custom field "Total Lead Time".

For example: Total Lead Time = 1 minute 35 seconds + 1 minute 57 seconds + 7 days 18 hours 44 minutes 13 seconds

My automation is as follows:

But, when this rule is trigerred, I'm not getting any result in the dashboard (column Total Lead Time).

Can you please advise what is wrong?

Thanks.

[Kseniia Trushnikova]

Hi @Krishtee,

I'm not sure if it's even possible to sum up such values. {{issue.created.diff(issue.updated)}} returns a string, but only numbers can be summed up.

Anyway, I'd recommend you to create another question so other community users can advise you on it.

[Krishtee]

Hi @Kseniia Trushnikova

Thanks.

Yes I will create another question.

[Melissa C]

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 

[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:

Hope this helps!

[Krishtee]

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]

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

Good answer though!