have a aggregation modifier #fromTopToMe #fromBottomToMe
To provide a backlog forecast it is essential to show what content could be done within a certain time or time budget. If we configure the budget in a top level issues custom field, structure could SUM not only by level, but also the contents of the current list of elements (eg. by priority) and a formula could show from which element the budget is overspent.
Got it, thanks, Matthias!
yes, this is exactly what we need! It would help many companies to give forecasts and more.
Btw: The "red line" is optional as we could use a formula column showing "ok" or "exeeded" or "inbudget" and "currently not in budget" instead of ot.
Thanks a lot for your support!
So, if I understand you correctly, you'd like to have a kind of a "running total", going from top to bottom over the top-level issues (or maybe "sibling" issues under a common parent), accruing the total value and, when a threshold is reached, showing something like a thick red line there.
Does it sound right?
We actually had a request like that before... This is a great idea, but it will need us to implement it as a feature. Unfortunately, it can't be done with the current formulas, which are entirely bottom-up (SUM and the like) or top-down (PARENT, JOIN).
Thanks Julia for your quick response. I saw that aggregations, but I cannot figure out how i could realize a SUM of all Rows above or below the position of the current row. And I checked again, but can still not find how I would implement that. Do you have any hint on this?
AdminStructure Team (Admin, ALM Works) commented
Thank you for your question! We already added aditional modifiers in the version 4.3: https://wiki.almworks.com/x/4w9KAg. Note, that there are several modifiersfor that aggregation: you can include the current row, can exclude it, can count leaves only (check #children, #leaves, #subtree). Will it helps?
Please do not hesitate to ask if you have any questions!
ALM Works Team