Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,462,457
Community Members
 
Community Events
176
Community Groups

Structure formula question: Get total story points in a Structure?

Hello. I have  Structure board that is built via a query at the top level. I typically group it using the Component field. I would like to create a formula column showing each group's percentage of the story points in the entire Structure board.

What I can't figure out is how to access the number representing the sum of all points in the Structure. Is there a number representing this, or a way to calculate it?

Thank you.

 

 

2 answers

example.pngAttached is an example of what I do if it helps.

Story Points - choose Sum over sub items and chose sigma story points.

Using formulas : IF (Status = "Closed"; StoryPoints) - for closed story points

for sized Issue Count : COUNT#all {Story Points}

Total Issues : IF(itemtype = 'issue';COUNT#all{Summary} and issueType != "Epic")

Resolved Total : IF(itemtype="issue"; COUNT#all{Summary} and issueType != "Epic" and (Status = "Resolved" or Status = "Verified"))

Closed Total : IF(itemtype = "issue"; COUNT#all{Summary} and issueType != "Epic" and Status = "Closed")

 

Rich

0 votes

Hello,

Thanks for your post!

We are planning to add the ability to aggregate at the sibling level, but we are unable to communicate a timeline as to when this is going to happen. I will post here when the improvement has been released.

I'm sorry I don't have better news. Please reach out to support@almworks if you have any other additional questions.

 

Best Regards,

Vlad

ALM Works

Thank you Vlad. I will look forward to it.

You are very welcome! Sounds good! 

@Vlad[ALM Works] Hello Vlad. Has this functionality been added to the roadmap? I would also like to show a percentage of all Time Spent / Time Remaining shown on the Structure board. 

Hello!

This is currently in our backlog but it's a popular request and we hope to have it scheduled soon. I will let you know once we know more. Are you looking to show a percentage from the Sum Time Spent/ Sum Remaining Estimate of your whole structure or do you mean something else?

Please feel free to elaborate on the use case so I can either recommend a Formula, if possible or share your use case with our Product Team.

Best Regards,

Vlad

Thanks for the reply! The answer to your question is yes. However, I would also like to have any number-based field do this. Here is a use case:

We have a custom field that sums up days spent on all tasks in an Epic. And, I have a Structure board that shows five epics. Each epic had one day spent on them. So, total days spent as shown on the Structure board = 5.

Allow me to access the total of 5 as a variable, so that I can create a Percentage column called Percentage of Days Spent, such that each item shows 20%.

Please allow this for any built-in or custom number-based field, such as Story Points.

Please let me know if I can clarify on that use case further.

Excellent! Thank you so much for sharing your feedback. This is what we are planning for but I'll make sure to share your thoughts with our Product Team. I will reach out here once the feature has been implemented. 

If you have further questions or need additional help with Structure, please feel free to reach out to our Support Team at support@almworks.com.

Best Regards,

Vlad

Hello Claudine,

I just wanted to let you know that the described calculation can be possible using the PARENT{SUM#children{ ... }} function that was added in Structure 6.0. So please feel free to try the function on this version or on a later one.

And if you need any assistance with the Formula column, please don't hesitate to contact us directly via support.almworks.com for proper support.

Best regards,
Stepan Kholodov
ALM Works

Like ilia kassianenko likes this

@Stepan Kholodov _ALM Works_ Is this calculation in Jira cloud as well ?

e.g.  PARENT(SUM{...})

Like # people like this

Hello @ilia kassianenko ,

David from ALM Works here. 

The formula that Stepan provided, PARENT{SUM#children{ ... }}  ,does work on Cloud as well!  

Best,
David

Like # people like this

Hi @ilia kassianenko,

Nice to see you using Formulas on Cloud already :) Speaking of which, you're more than welcome to attend our upcoming virtual event – Structure Formulas: Unleash Data Superpowers in Atlassian Cloud – in case you'd like to learn more about the feature and use cases. Hope to see you there!

Best, 
Kathryn

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events