Your executive dashboard is not lying to you on purpose. It was never built to survive a bad month.
Five workstreams report status every week. Someone, on a deadline, rolls those five into the one number the executive actually has time to read. That assembly step, not any individual report, is where the program actually gets misrepresented.
The person building the rollup is not lying either. They are averaging. Two teams say yellow, one says red, two say green, and the instinct under a deadline is to land the summary somewhere in the middle.
Program risk does not average
A single red workstream with a hard dependency can sink four green ones. That is not a hypothetical, it is how critical paths behave. A rollup built by consensus, five people each softening their own number by one shade so they are not the reason the top line turns red, erases exactly the signal an executive needs to see.
The failure here is not dishonesty. It is a design flaw in how the number gets made. Nobody in that chain set out to obscure risk. Each of them made a locally reasonable choice under time pressure, and the sum of five reasonable choices is a dashboard that is technically accurate and functionally useless.
What a source of record actually requires
A real source of record has three properties a rollup slide does not.
First, it shows the worst input, not the average one. If any workstream is red on a hard dependency, the top line is red. There is no vote.
Second, it is traceable to the person who reported the underlying number, not the person who assembled the summary. When a status turns out to be wrong, the fix belongs to whoever owns the fact, not whoever owns the slide.
Third, it updates on the cadence the underlying facts change, not on the cadence of the executive meeting. A dashboard that only refreshes for Tuesday's steering committee is reporting last week's risk with this week's date on it.
Why removing the manual step is political, not technical
Every program I have taken over already has the technical capability to automate this. The blocker is never the tooling. It is that removing the manual rollup removes a layer of control from whoever currently owns that slide, and that person usually has good reasons, career reasons, not dishonest ones, for wanting to keep it.
An automated source of record takes the shading decision away from a person and hands it to a rule everyone agreed to in advance, while everyone was calm. That is a harder conversation than any data pipeline. It is also the only version of the fix that survives a bad month, which is precisely the month it needs to.
