RYG Balls average
hello,
i am looking to find a way to do an average with the RYG balls.
ex: 2 green, 2 yellow, 2 red should have should show yellow ball for the overall project.
is this something possible?
thanks for your help
Comments
-
I can't help you with the method, but can I offer some thoughts?
When rolling up status (which isn't a great plan anyway), I always use the worse indicator rather than average.
e.g. if your project has 1 red indicator, it overrides 999 greens or yellows and I'd be reporting the overall status as red because you have an activity which isn't going to make it.
May be better to report on the number of reds, yellows and greens separately?
Not sure what metrics you are using or how you have defined RYG so happy to wind-my-neck-in if necessary!
Help Article Resources
Categories
Check out the Formula Handbook template!