search

opensrp / opensrp-client-chw

Reference OpenSRP application for Community Health Workers (CHWs)
Other
3 stars 21 forks source link

WCARO DRC Data mismatch between chw app and dashboard #1835

Closed ageryck closed 3 years ago

ageryck commented 3 years ago

Client reported data mismatch between CHW app and records as shown on their superset dashboard, this is a follow up issue after applying a sync failure fix currently being tested for DRC.

Client shared this file as their reported findings on the mismatch, red highlights are of concern and up for investigations.

ageryck commented 3 years ago

Data difference reported by client on device and dashboard here are findings;

  1. Client is making a direct comparison on data indicated on CHW device and Data displayed in their PowerBI dashboard (apparently pulling from canopy DB)
  2. Queries on CHW app for 4 indicators (# of HH, ANC, PNC, Child Clients) are factoring remove events where as queries on dashboard do not appear to factor remove events sample results here
  3. There exist instances/scenarios where data is available on canopy DB yet client PowerBI is reporting missing data. Recommendation on this is particular indicators needs to be validated by the data analysts
ageryck commented 3 years ago

After updating new sync fixes for DRC no more such cases have been reported