Dashboard Metrics for Grant-Funded Programs

Separate accountability metrics from operating metrics

Accountability metrics are defined by the award: reach, spend, deliverables, outcomes against targets. They change slowly and must be reproducible months later.

Operating metrics are defined by the team: throughput, backlog, data quality, drop-off points, time to resolution. They change weekly and exist to prompt action. Put them on separate views, even if they share a data source.

Write the definition before the chart

Most dashboard disputes are definition disputes. A short data dictionary published alongside the dashboard resolves them before they start.

• The exact numerator and denominator.
• The date field that determines which period a record falls into.
• Inclusions, exclusions, and how duplicates are handled.
• The refresh frequency and the source system of record.
• The named owner of the definition.

Design each view around one question

Give every view a title that is a question — "Are we on track for the year-two target?" — and remove anything on the page that does not help answer it. If a chart is there because the data exists rather than because someone decides with it, it is costing attention.

Show trend and context, not just the current number

A single figure invites misreading. Pair each headline metric with its trend over time, the comparison point that matters (target, prior period, or comparable site), and an indication of data completeness for the current period, which is almost always partial.

Common pitfalls

• Reporting cumulative totals only — they always rise and therefore always look fine.
• Mixing periods with different data completeness on the same axis.
• Averages over small denominators presented without the denominator.
• Traffic-light colouring with no documented threshold behind it.
• No stated update time, so users cannot tell whether they are seeing today's picture.