Structure column: Story Points SUM and AVG

Visa Kask May 22, 2023

Hi

 

I have column "Story Points SUM" but is it possible to create also "Story Points AVG". I mean that column not summarize not shows average results?

1 answer

1 accepted

2 votes
Answer accepted
David Niro
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
May 23, 2023

Hello @Visa Kask ,

Welcome to the Community!

It is possible to do this using Formula Columns. We just need to count the number of issues and divide the sum by the number returned.

A quick example is this:

with _children = COUNT#children{1}:
IF _children > 0:

SUM#children{storypoints}/_children

If an issue has "children" in the hierarchy, it will sum the story points and then divide by the number of children.  Based on the hierarchy in your structure, it may need some adjustments to the modifiers (#children).

Please let me know if this helps!

Best,
David

Suggest an answer

Log in or Sign up to answer