Skip to main content

Milestone Trend Analysis Component

The Milestone Trend Analysis (MTA) component plots the forecast completion dates of selected milestones across multiple successive reporting periods. Each line on the chart represents one milestone, and its slope shows whether the forecast date is stable, slipping to the right, or recovering to the left. MTA charts are a standard project controls output for demonstrating schedule trend performance to clients and stakeholders.

Reading an MTA chart

  • A horizontal line means the milestone's forecast date is unchanged — schedule is stable.
  • A line sloping right (up) means the forecast date is slipping — schedule is deteriorating.
  • A line sloping left (down) means the forecast date is recovering — schedule is improving.
  • Lines converging at the diagonal (where reporting period = forecast date) indicate completion.

Presets

PresetDescription
Key Milestones OnlyShows only milestones flagged as key/critical. Suitable for executive reports.
Full Programme MilestonesAll milestones in the schedule.
Milestone by DisciplineGroups milestones by discipline, using color per discipline.
Schedule Variance FocusHighlights milestones with drift exceeding a configurable threshold.

Data binding

PropertyDescription
Milestone fieldField identifying each milestone (ID and/or name).
Reporting period fieldThe dimension representing successive reporting periods (e.g., monthly report date).
Forecast date fieldThe forecast completion date for each milestone as recorded in each reporting period.
Baseline date fieldOptional fixed baseline target date for each milestone. Shown as a horizontal reference line per milestone.
Group by fieldOptional field to color-code milestone lines by group (discipline, phase, contractor).

Baseline date display

When a baseline date field is bound, each milestone's baseline target date is shown as:

OptionDescription
Horizontal reference lineA dashed horizontal line at the baseline date for each milestone.
Baseline markerA distinct point marker on the Y axis.
BothLine and marker combined.

Schedule drift indicator

Highlight milestones where schedule drift has exceeded a threshold:

PropertyDescription
Drift thresholdNumber of days of slip from baseline to trigger a highlight.
Drift highlight colorColor applied to lines exceeding the threshold.
Drift annotationOptional label showing the number of days of slip on the milestone line.

Grouping dimensions

Group milestone lines to reduce visual clutter on charts with many milestones:

  1. Set the Group by field to a dimension (e.g., Phase).
  2. Lines within a group share a base color with shade variations per milestone.
  3. A group legend entry covers all milestones in the group.
  4. Use the group filter in the chart's Properties → Filter to show/hide groups.

Layout options

OptionDescription
Reporting period axis formatMonth name, Year-Month, or custom format.
Forecast date axis formatDate format for the Y axis.
Diagonal reference lineShow the 45° diagonal where forecast date = reporting period. Points on this line indicate the milestone has been completed in that period.
Milestone label positionLabels at the end of each line (right), at the start (left), or hidden (use legend only).
LegendShow/hide. Recommended on for charts with > 4 milestones.

Good practice

  • Limit visible milestones to ≤ 15 per chart for readability. Use the Key Milestones Only preset or filters to reduce the set.
  • Always show the diagonal reference line so readers can interpret which milestones have been completed.
  • Use the drift highlight to immediately draw attention to milestones at risk.
  • For formal monthly reports, combine the MTA chart with a table listing each milestone's baseline date, latest forecast date, and days of slip.