Hello,
I need some help creating performance calculations/project health metrics on my dashboard. I have a list of projects with scheduled start and end dates, and associated actual start and end dates. I need measures for how we are performing agaisnst the schedule (are we behind, on time, or ahead of schedule for each task). Any ideas would be helpful! Below is a sample excel document with the information. Thank you for your time and consideration!
| District | Task | Start Date | End Date | Duration | Actual Start | Actual End | Today |
| Oregon | Actual Timeline | 3/12/2019 | 8/10/2019 | 151 | | | 7/12/2019 |
| Oregon | Go Live | 7/17/2019 | 7/17/2019 | 0 | | | 7/12/2019 |
| Oregon | Discovery | 3/19/2019 | 3/19/2019 | 0 | 3/13/2019 | 3/13/2019 | 7/12/2019 |
| Oregon | Asset Hierarchy | 3/19/2019 | 6/17/2019 | 90 | 3/21/2019 | 6/20/2019 | 7/12/2019 |
| Oregon | OMS Activity to Maximo Migration | 7/10/2019 | 7/10/2019 | 0 | 7/10/2019 | 7/10/2019 | 7/12/2019 |
| Oregon | Training Complete | 7/24/2019 | 7/24/2019 | 0 | | | 7/12/2019 |
| Oregon | On Site Support Start | 7/25/2019 | 8/17/2019 | 23 | | | 7/12/2019 |
