KPI Calculations
The following KPI calculations are used within Power BI Paginated Status Reports.
Altus Paginated Status Reports
Project or Program or Portfolio Status KPI
| KPI Visual | Definition | Value |
|---|---|---|
| Box with Cross | No KPI | blank |
| Green Circle | On Track | 0 |
| Yellow Square | On Watch | 1 |
| Red Diamond | Overdue | 2 |
| Box with Cross | Custom KPI | 3 |
| Empty Orange Circle | Others | 4 |
Deliverable KPI
| KPI Visual | Definition | Calculation | Value |
|---|---|---|---|
| Green tick | Completed | statuscodename = 'Completed' or 'Cancelled |
0 |
| Yellow Square | Due Date missing | sensei_duedate is null |
3 |
| Red Diamond | Overdue | sensei_duedate < Getdate() |
4 |
Issues KPI
| KPI Visual | Definition | Value |
|---|---|---|
| Green tick | Completed | 0 |
| Green Circle | On Track | 1 |
| Empty Circle | Postponed | 2 |
| Yellow Square | Due Date missing | 3 |
| Red Diamond | Overdue | 4 |
Risks KPI
| KPI Visual | Definition | Value |
|---|---|---|
| Green tick | Completed | 0 |
| Green Circle | On Track | 1 |
| Empty Circle | Postponed | 2 |
| Yellow Square | Due Date missing | 3 |
| Red Diamond | Overdue | 4 |