[APF Dashboard Report] : EDD vs Actual Delivery

kameshbhariya commented 5 months ago

[ ] Make the report in the pre-release.
[ ] EDD vs Actual Delivery report is a new report to be added for the client in superset. It is being used to track the number of expected and actual deliveries this month.
[ ] An aggregate report and linelist depicting the complete details of the pregnant women should be displayed. The detailed requirements are available in the analysis link shared below.
[ ] It will have filters for filtering the data based on the following:
1. Type of Village
2. Project/Block (By default)
3. Age group
4. High risk condition
5. Block (By Default)
6. Type of mother (Normal/High Risk)
7. Date Range
[ ] Link to the analysis

nupoorkhandelwal commented 3 months ago

Dashboard link - here

nupoorkhandelwal commented 3 months ago

Dashboard link - here

sachsk commented 3 months ago

@nupoorkhandelwal

[x] there are multiple delivery forms for single enrolment is present in the DB so you have to take only schedule and latest encounter for that create CTE and take latest enc.
[x] use enrolment id for count

avniproject / apfodishanutrition