In our LeanIX data model, each ISMS Initiative is linked to multiple ISMS Milestones. The milestone status can be Not Started, In Progress, or Completed. We would like to calculate the overall progress of the ISMS Initiative based on the statuses of its related milestones. Could you explain the best way to implement this calculation in LeanIX?
For ecample, an ISMS Initiative called "Implement Privileged Access Management" is linked to four ISMS Milestones. Each milestone has a status on the ISMS Milestone fact sheet:
MilestoneStatusScore
| PAM Design Approved | Completed | 1 |
| PAM Solution Procured | Completed | 1 |
| PAM Deployment Started | In Progress | 0.5 |
| PAM Production Rollout | Not Started | 0 |
If we assign the scores Completed = 1, In Progress = 0.5, and Not Started = 0, the overall progress of the initiative can be calculated as:
if we want to calculate the percentage of milestones that are fully completed only, the calculation would be
Completed Milestones / Total Milestones= 2 / 4= 50%