[Report] Vaccination coverage

[sachsk]

Context

As we are unable to add this charts in the dashboard due to metabase filter limitations we have decided to create a separate report for each graph with their linelist

Reports

Filters: Date filter on the due date

• [x] Vaccination coverage area wise (Bar graph)

• Numerator: Count of unique children whose - all the vaccine's which have due date in the year filter are completed ie. have completion date in the selected time-range

• Denominator: Count of unique children who has any one vaccine's due date in the selected time-range

• [x] Vaccination coverage (Pie Chart)

• Numerator: Count of unique children whose - all the vaccine's which have due date in the year filter are completed ie. have completion date in the selected time-range

• Denominator: Count of unique children who has any one vaccine's due date in the selected time-range

• [x] Vaccination coverage monthly trend (bar graph)

• Logic : Month wise percentage of vaccination coverage in the current year(selected duration in the date filter) ie. group the following by Month of due date

• Numerator: Count of unique children whose - all the vaccine's which have due date in the year filter are completed ie. have completion date in the selected time-range

• Denominator: Count of unique children who has any one vaccine's due date in the selected time-range

---

• [x] Vaccination complete linelist
• Logic : List of unique children whose - all the vaccine's which have due date in the year filter are completed ie. have completion date in the selected time-range
• Data to show: show all individual, address and vaccination related data

---

• [x] Vaccination due linelist
• Logic : list of unique children who has any one vaccine's due date in the selected time-range
• Data to show: show all individual, address and vaccination related data

Sample image

[vedfordev]

Folder Link : Link

Reference Query:

select  cicv.program_enrolment_id,
                      c.base_date::date + ((item_detail_status::json->>0)::json->>'end')::int as due_date,
                      completion_date,
                      item_detail_state
from checklist_item_checklist_view cicv
left join checklist c on cicv.checklist_id = c.id
where item_detail_state = 'Due'
order by 1;

[sachsk]

@vedfordev

• [x] Is voided check is missing
• [x] Make date filter mandatory
• [x] count is miss matching
• [x] In linelist show the data as per requirement