We're using confluence to track our project portfolio progress, but we'd like to aggregate a number of statuses into one score that can be then automatically updated. More specifically, we want to define values to the Green, Yellow, and Red Statuses (3, 2, 1, respectively) and have that calculate across the various project KPI Categories (Schedule, Budget, Scope) for a final project score. Here's an example:
Schedule: Green (3)
Budget: Yellow (2)
Scope: Red (1)
Total Score = 6
Can this be done?
