Unexpected rows in ICB sheet in KPI report

rcpch / rcpch-audit-engine

Epilepsy12 Audit Platform

https://e12.rcpch.ac.uk/

GNU Affero General Public License v3.0

5 stars 5 forks source link

Unexpected rows in ICB sheet in KPI report #931

Closed mbarton closed 3 months ago

mbarton commented 3 months ago

NHS BIRMINGHAM AND SOLIHULL INTEGRATED CARE BOARD have rows in the report showing 100, 1, 1 but no corresponding ICBKPIAggregation model rows

mbarton commented 3 months ago

I would like to spot check this filter in the django shell:

https://github.com/rcpch/rcpch-audit-engine/blob/f1bad97abfa941a84ada619493bd45a8c492c2a7/epilepsy12/common_view_functions/aggregate_by.py#L922

It appears to expect a one to one relation between what's defined in the constants list and what rows there are in the database. This would be broken after we removed all KPI rows yesterday that would not be regenerated automatically.

mbarton commented 3 months ago

Fixed in #941