[JSCS Support] Relative Screening report

[nupoorkhandelwal]

https://avni.freshdesk.com/a/tickets/1970

We already have created Relative screening reports but not yet QAed, so we need to review, QA and share them to client-

ETL report for Annupur - https://reporting.avniproject.org/question/2153-do-not-use-relative-screening-report-anuppur
Old report for Annupur - https://reporting.avniproject.org/question/242-relative-screening-report

ETL report for Dindori - https://reporting.avniproject.org/question/2337-relative-screening-report-dindori
Old report for Dindori - https://reporting.avniproject.org/question/1547-relative-screening-report

[Gojo-Taqi]

Old reports link :- https://reporting.avniproject.org/collection/445-c-old-table-reports
New reports link :- https://reporting.avniproject.org/collection/410-a-reports-with-new-tables

[Dinesh2019]

for a Summary of sick cell testing, we have the value mismatch between the old and new report
for eg: for total registration new report value is 17,931 and the old report value is 17,929

[Dinesh2019]

we are blocked for testing due to the error : ERROR: relation "jscs.jscs_villages_view" does not exist Position: 3650 in the line-list-of-all-registered-beneficiaries-new with affect all the report

[Gojo-Taqi]

Fixed the issue, moving the card back to QA ready

[Dinesh2019]

1. Still we are facing the issue this time issue related to most of the reports under Anuppur location for example: for the report, line-list-of-ss-genotype-cases pointed to the line-list-of-all-registered-beneficiaries under the wrong directory called saved questions.
2. For the Dindori location the old report doesn't have any values

[utkarshavni]

This has been moved on hold since it will be picked up once all the ETL migrations are done.

[vedfordev]

@nupoorkhandelwal

1. report for Annupur : old one takes 25 minutes to execute and count have mismatched with new one.
2. report for Dindori : old one takes 40 minutes to execute and shows 0 count while new one has records.