Open finding avg age (days)
Average days a finding has been open. ISO 9001 expects a defined timeframe; >90 days is a yellow flag.
qualityDQ pass
qms.findings_avg_age_days
0.5 d
days · 5/3/2026, 4:46:18 AM
- Source
- qms-in-a-box (mvp-02)
- Owner
- Quality Manager
- Versions
- 1
30-day trend
Current published version
Published 5/2/2026 by seed-script
v1
Formula
avg(now() - found_at) where status not in ('verified_closed','deferred')Source SQL
select round(avg(extract(epoch from (now() - found_at)) / 86400.0)::numeric, 2) as value
from qms_audit_findings
where status not in ('verified_closed', 'deferred')Data-quality assertions (1)
- rangeNon-negative dayserror
Recent snapshots (32)
| Captured | Value | DQ | Notes |
|---|---|---|---|
| 5/3/2026, 4:46:18 AM | 0.5 d | DQ pass | |
| 5/2/2026, 6:43:18 PM | 0.1 d | DQ pass | |
| 5/1/2026, 6:44:03 PM | 0.1 d | DQ pass | synthetic |
| 4/30/2026, 6:44:03 PM | 0.1 d | DQ pass | synthetic |
| 4/29/2026, 6:44:03 PM | 0.1 d | DQ pass | synthetic |
| 4/28/2026, 6:44:03 PM | 0.1 d | DQ pass | synthetic |
| 4/27/2026, 6:44:04 PM | 0.1 d | DQ pass | synthetic |
| 4/26/2026, 6:44:04 PM | 0.1 d | DQ pass | synthetic |
| 4/25/2026, 6:44:04 PM | 0.1 d | DQ pass | synthetic |
| 4/24/2026, 6:44:04 PM | 0.1 d | DQ pass | synthetic |
| 4/23/2026, 6:44:04 PM | 0.1 d | DQ pass | synthetic |
| 4/22/2026, 6:44:04 PM | 0.1 d | DQ pass | synthetic |
| 4/21/2026, 6:44:04 PM | 0.1 d | DQ pass | synthetic |
| 4/20/2026, 6:44:04 PM | 0.1 d | DQ pass | synthetic |
| 4/19/2026, 6:44:05 PM | 0.1 d | DQ pass | synthetic |
| 4/18/2026, 6:44:05 PM | 0.1 d | DQ pass | synthetic |
| 4/17/2026, 6:44:05 PM | 0.1 d | DQ pass | synthetic |
| 4/16/2026, 6:44:05 PM | 0.1 d | DQ pass | synthetic |
| 4/15/2026, 6:44:05 PM | 0.1 d | DQ pass | synthetic |
| 4/14/2026, 6:44:05 PM | 0.1 d | DQ pass | synthetic |
| 4/13/2026, 6:44:05 PM | 0.1 d | DQ pass | synthetic |
| 4/12/2026, 6:44:06 PM | 0.1 d | DQ pass | synthetic |
| 4/11/2026, 6:44:06 PM | 0.1 d | DQ pass | synthetic |
| 4/10/2026, 6:44:06 PM | 0.1 d | DQ pass | synthetic |
| 4/9/2026, 6:44:06 PM | 0.1 d | DQ pass | synthetic |
| 4/8/2026, 6:44:06 PM | 0.1 d | DQ pass | synthetic |
| 4/7/2026, 6:44:06 PM | 0.1 d | DQ pass | synthetic |
| 4/6/2026, 6:44:06 PM | 0.1 d | DQ pass | synthetic |
| 4/5/2026, 6:44:07 PM | 0.1 d | DQ pass | synthetic |
| 4/4/2026, 6:44:07 PM | 0.1 d | DQ pass | synthetic |