A weekly reporting workflow that stops when its sources are incomplete

说明与用途

实现了一个报告工作流，当源数据缺失或过期时阻止批准，确保只有准确的报告才能被批准。

问题

Weekly reports can contain plausible numbers yet be misleading if source data is missing or stale, leading to uninformed decisions.

结果

The prototype demonstrates a robust reporting pipeline that halts when source data is incomplete or stale, ensuring only accurate reports are approved.

工作流

• Define metric sources and their freshness thresholds.
• Generate report from synthetic billing, CRM, and support snapshots.
• If a source is missing or stale, omit its metrics and add a blocker.
• Set report status to "blocked" if any blockers exist, otherwise "draft".
• Compute a SHA‑256 digest of the report content and input digest.
• When approving, verify the digest matches, the status is "draft", and no blockers remain.
• Reject approval if any condition fails.
• Record reviewer name and timestamp on successful approval.

证据

The report keeps the metrics it can calculate, omits the unavailable ones and records a blocker.

来源

The approval function recomputes it and checks that the report is still a draft without blockers.

来源