Automated progress bars (related to sub tasks)

Follow

Niklas Schöttner

• August 29, 2016 10:08

Hello all,

I have a structure of projects with related deliverables and tasks that are related to those deliverables ( projects <- deliverables <- tasks).
My idea was to keep the progress bar of the tasks updated and that the progress bars of deliverables and projects change automatically based on the average of the tasks (or deliverables) on the lower level.
Unfortunately they have to be changed manually right now.

Any ideas or solutions?
Thanks in advance.

Niklas

2

• 

  Ethan Unzicker

  • August 29, 2016 17:48

  This is definitely a great idea! The progress bars are kiiiinda pointless right now because a lot of changes to it are arbitrary. Having this be automated would be fantastic!

  0

  Comment actions Permalink
• 

  Kent Watson

  • August 30, 2016 20:59

  HI Niklas,

   

  This can be achieved if you are using GlobiFlow.

  Alternately you can ditch your progress bar for your deliverables and projects and replace them with calculated fields

  Deliverable Progress = @Avg of Task Progress

  Project Progress = @Avg of Deliverable Progress

  In the properties of the calculation field you can set the units to "%"

  0

  Comment actions Permalink
• 

  Niklas Schöttner

  • August 31, 2016 12:01

  Hello Kent,
  
  thanks a lot.
  I used the calculated fields to show the progress.
  
  Problem solved! :)

  0

  Comment actions Permalink
• 

  Victoria Aparicio

  • December 13, 2016 18:48

  Hello, I want to do the same, I want to show the avg of some fields in a calculation field, but I want to show like the progressbar.

  Please help me

  0

  Comment actions Permalink
• 

  Kent Watson

  • December 13, 2016 23:39

  Hi Victoria,

  You could try this.  I haven't tested it when the average progress is 0 or 100.  Let me know if there are any issues

  var prog = Math.floor(@Avg of Progress * 500/100);
  var bal = 500 - prog;
  var col = "677BDE";
  var txt = Math.floor(@Avg of Progress).toString();
  write = "![](http://dummyimage.com/" + prog + "x" + 25 + "/" + col + "/" + "FFFFFF" + ".png&text=" + txt.toUpperCase() + ")" + "![](http://dummyimage.com/" + bal + "x" + 25 + "/C0C0C0/C0C0C0.png&text=0)";

   

  Good luck!

   

  0

  Comment actions Permalink

Please sign in to leave a comment.