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

Help with formula: calculating comment average over the last 20 days

Tiara Pequeno

Hi everyone!
I'm trying to create an automation that calculates the average number of comments over the last 20 days for all issues that have data in the custom field “Comentários 20 dias [Paragraph]”, but I’m getting the formula wrong.
Could anyone please tell me the correct way to calculate this average using smart values and save the result into a numeric field?

Accepted answers

Anthony Morais

Hi @Tiara Pequeno

Try editing your custom field using the following formula and let me know if it works:

{{#=}}{{lookupIssues.size}} / 20 * 100{{/}}

Regards,
Anthony

All comments

Anthony Morais

Hi @Tiara Pequeno

Try editing your custom field using the following formula and let me know if it works:

{{#=}}{{lookupIssues.size}} / 20 * 100{{/}}

Regards,
Anthony

Tiara Pequeno

thank you very much for the help

Anthony Morais

Wow! I'm so glad it worked out!

Bill Sheboy

Hi @Tiara Pequeno -- Welcome to the Atlassian Community!

Which of these are you trying to calculate:

the average number of work items created over the last 20 days, or
the average number of comments added to a set of work items over the last 20 days

If if is the second one, please note the comments are list of things within the list of work items, and that will require additional handling to iterate them, filter by their create date, and then sum to determine the average.

Kind regards,
Bill

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud