Automated progress bars (related to sub tasks)
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.
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 "%"
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)";
Please sign in to leave a comment.