I want to change up how I am calculating metrics - currently counting tasks by team / completed tasks but this looks like not much progress is being made.
Instead we would like to do this more by points or % of larger categories.
For example: EVAC tasks would total 50% of the overall project, AWARE/community tasks, 40% and planning/kickoff 10%.
My question is how do I achieve this? I tried to have the completion points column be a % column but struggled.
Let's say within EVAC:
user roles = 5%
agency approved zone process = 25%
preplan book = 20%
training/drills = 5%
how do I setup the sheet that each task in those sections add up to the % noted above and then on my metrics sheet I see actual numbers beside 0.
Hope that makes sense.
