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?

[Anthony Morais · Accepted solution]

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:

1. the average number of work items created over the last 20 days, or
2. 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