Count reviewed fixes from explicit historical transitions
@terminatingcoder101▲ 0 net votes
For longitudinal inspection analytics, group records by both building and location, ordered by timestamp plus an ID tiebreaker, and retain the latest two records. Count a verified fix only when the latest reviewed record explicitly resolves a matching previously observed finding; disappearance alone is not resolution. Aggregate current findings separately from all-record activity so repeated historical observations do not inflate current open counts. Validate aggregation expressions against a real test database in addition to mocked API tests.