Skip to main content
Performance Index Report

​
Overview

The Performance Index Report strips earned value analysis down to its two most critical health indicators (SPI and CPI) and plots them as spline curves over your project timeline. This is your at-a-glance trend chart: a quick look tells you whether performance is improving, degrading, or holding steady. Below the chart, a data grid shows the exact SPI and CPI values for every reporting period from project start through the selected period. URL: /EarnedValue/PerformanceIndexReport/Index

​
Prerequisites

  • Select a project and reporting period. Both are required before the chart and data grid load.

​
Reading the Chart

Two spline curves are plotted over your project timeline: A value of exactly 1.0 means performance exactly matches the plan. The trend is as important as the current value. An SPI of 0.85 that has been steadily climbing over several periods tells a different story than an SPI of 0.85 that has been falling. Chart interactions:
  • Click any legend item to show or hide that curve.
  • Hover over a data point to see the exact index value for that period.
  • Zoom by clicking and dragging on the chart to focus on a specific date or value range. Both the argument (time) axis and value axis support zooming.
  • Pan by holding and dragging after zooming to scroll along either axis.
Chart subtitle: When secondary filters are active (WBS, Work Package, CAM, Start/End Date), the chart subtitle automatically updates to list all active filter values; for example, “Project: My Project | Reporting Period: Jan 2024 | WBS: 1.01 | CAM: Smith”. This subtitle carries through to the Excel export.

​
Data Grid

Below the chart, a pivot-style data grid shows the SPI and CPI values for every reporting period from project start through the selected period.
  • Rows: One row for SPI, one row for CPI.
  • Columns: One column per reporting period, labeled with the period identifier (month/year in Monthly mode, year in Yearly mode). Columns run left to right from earliest period to the selected period.
This grid is useful for reviewing exact index values when the chart curve is too compressed to read precisely, or for verifying the data behind a particular point on the chart.

​
Available Filters

The Project and Reporting Period selectors appear in the page header. All other filters are in the left-side filter panel, which activates after a reporting period is selected. Currency Format options:

​
When to Use This Report

Use the Performance Index Report when you need a quick trend summary for a status meeting or executive briefing. Where the CPR shows you the detail behind each number, the Performance Index Report shows the trajectory; whether things are getting better or worse over time. If both SPI and CPI are trending toward 1.0, the project is recovering. If either index is trending away from 1.0, early corrective action is needed. Use the WBS and Work Package filters to narrow the curves to a specific area of the project when investigating a localized performance issue, then compare those curves against the project-wide view. Use the Axis toggle to switch between monthly granularity (useful for recent periods) and yearly (useful for long-range projects to see the full arc).

​
Exporting

Click the Download icon and select Export to Excel to download EVPerformanceIndex.xlsx. The workbook contains two sheets: