Is there a way to count/total a number field of multiple issues in a filter or roadmap?

[Wendy Benson]

For example, I have a field called '# of Apps' in the issue type of Initiative (some have 1, another might have 6 or other). Can I get a sub-total, total, sum, or count of the number in this field for all Initiatives to display in a filter or roadmap? So if I have 6 Initiatives with a total of 15 from the # of Apps field, how can I show this?

[Alexey Matveev · Accepted solution]

Hello,

When you add this post function you have a field to enter the value for your custom field. Enter there the name of the required user.

[kmcnamee]

What value do I enter?

Is it the email address of the user or an actual "user name"?

[Alexey Matveev]

it is the name of the user. For example, admin

[kmcnamee]

OK. This worked if I added me as "kevin.mcnamee". Nice.

[Alexey Matveev]

If my asnwer helped you, kindly accept my answer.

[kmcnamee]

After a little more testing, this works very nicely. Thanks!

[Alexey Matveev]

You are welcome!

[Mattias Ohlsson]

I would create a filter, with your specific validation rules, -> state you want to watch for your issues. With this filter I would then create a subscription with your wanted regularity -> Daily, weekly, or hourly. Then you get mails when you have issues in that state, and you can take actions.

Cheers, Mattias

[kmcnamee]

OK, I created a filter that displays issues that were updated within the last minute (updated >= -1m). I then created a subscription that sent emails every minute (0 * * ? * *). This will ensure that users will get information immediately. The subscription frequency must match the filter time limit (i.e. one minute) so that users do not get notified more that once about an issue that was updated.

When I choose recipients I have to choose a JIRA group. So I will need to set that up.

Updates to an issue can be made in the Description field or as a comment. Description can be included as a column in the filter. However, without a column for comments (or more specifically 'latest comment'), the email will not include information added there

[kmcnamee]

I will go with the custom field solution this time. The resulting emails are more user-friendly. Thanks for the suggestion!