Articles in this section

See more

Aggregate or formula to calculate % complete

Avatar
Wes Williams
Updated
Follow 

Anyone found a way to calculate % complete at each iteration? maybe an aggregate or formula or combination. I want to be able to do % complete to compare values in a chart that are not equivalent. Such as % of budget vs. % story points complete. 

 

If I have to I can simply add a percent complete as properites for both values each iteration but I would rather calculate the % story points complete.

 

Thanks for any assistance with this.

 

Regards,

wes

Comments

2 comments

Sort by Date Votes
  • Avatar
    Suzie Prince

    Wes


    I have done this simply before using a formula on an iteration card. In the template I had I had an aggregate on an iteration called "velocity" and then a property called "planned size". I then created a formula called "% done" that = "velocity" / "Planned size" * 100


    I used this in a table such as:


     



    Does that meet your needs?


    Thanks


    - Suzie 

    0
    Comment actions Permalink
  • Avatar
    Wes Williams

    Hi Suzie,


     


    Thanks for the response.  Actually what I am trying to see is two numbers compared over time in a chart. Not the % complete for the iteration itself but the percent complete of user story points vs percent of budget spent at the end of each iteration.  See the screen shot for an example.


     


    Thanks,


    Wes

    0
    Comment actions Permalink

Please sign in to leave a comment.