Visualizer shows empty row for specific facilities against ACTUAL REPORTS

Data Visualizer shows empty row for specific facilities against when we select Data Type : Data Sets and then select Metric Type :ACTUAL_REPORTS for any data set . Snapshots and details are as follows :

  • API is not returning data related to actual reports and expected reports , Only for Specific facilities, for rest of all the facilities , the responses are fine.
  • Following is the exact api call:
    • /api/38/analytics?dimension=dx%3Aw0XyK5JubEA.ACTUAL_REPORTS%3Bw0XyK5JubEA.EXPECTED_REPORTS%3Bd5Gn787bj2I.ACTUAL_REPORTS%3Bd5Gn787bj2I.EXPECTED_REPORTS%3BoT5HtJ9i34d,ou%3Adk1w5YId4Bb,pe%3A20221219&displayProperty=NAME&includeNumDen=true&skipMeta=true&skipData=false
  • In this test case, i have passed parameter of ACTUAL_REPORTS as well along with the parameter of one of the disease OPD value in the same form. So it has returned the OPD value, but not the ACTUAL_reports value. ( The data set is marked complete, i have verified. ) Also the same response for Expected reports.
  • Its worth noting, its happening only for specific facilities.

This api call gives empty response for the specific facilities.While the same api call, with Orgunit shifted to the Filters, provides value as “2”

( Second scenario : API CALL : /api/38/analytics?dimension=dx%3Aw0XyK5JubEA.ACTUAL_REPORTS,pe%3A20230125%3B20230126%3B20230127%3B20230128%3B20230129%3B20230130%3B20230131%3B20230201&filter=ou%3Adk1w5YId4Bb%3BcOoGkZMiVVw&displayProperty=NAME&includeNumDen=true&skipMeta=true&skipData=false )

@zubair @adnan1 @Pamod @AzizUllah