I suggest Structure should ...

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.

3 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

5 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    Hi Igor,
    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!

  • AdminIgor Sereda (CEO / Founder, ALM Works) commented  ·   ·  Flag as inappropriate

    Hi Matthias,

    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).

    Kind regards,
    Igor

  • Anonymous commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    Hello Matthias,

    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!

    Julia,
    ALM Works Team

Feedback and Knowledge Base