[Phulwari] Create dashboard on metabase.

[garimadosar5]

Ref Doc - https://docs.google.com/document/d/1UtS_fZOJQE0r7l0yEvcbv0MZ_jKeHwOvjskGx0PF25g/edit

All the reports that will be used in creating the dashboard is mentioned below. Need to do the sum or count on reports and get the graph/chart.

Filters: Year, Month, Catchment, Phulwari (Year and Month are mandatory filters) Visualizations:

• [x] Total number of registered children - https://reporting.avniproject.org/question/1529
• [x] Total number of enrolled children - https://reporting.avniproject.org/question/1529 (Do not include exit cases)
• [x] Total number of Grade 3 children - https://reporting.avniproject.org/question/201
• [x] Total number of faltering children - https://reporting.avniproject.org/question/638
• [x] A pie chart showing Grade 1, Grade 2 and Grade 3 children - https://reporting.avniproject.org/question/201
• [x] Total number of due visits - https://reporting.avniproject.org/question/291
• [x] Total number of children graduated - https://reporting.avniproject.org/question/1529 (exited children)
• [x] Upon use of ‘Phulwari Filter’ i.e. on selection of a particular Phulwari, list of grade 3 children and list of faltering children should be displayed - https://reporting.avniproject.org/question/638 Visualizations to compare sector wise performance (all bar graphs):
• [x] Catchment vs. Number of enrolled children - https://reporting.avniproject.org/question/1529
• [x] Catchment vs. Number of grade 3 children - https://reporting.avniproject.org/question/201
• [x] Catchment vs. Number of grade 1 children - https://reporting.avniproject.org/question/201
• [x] Catchment vs. Number of faltering children - https://reporting.avniproject.org/question/638
• [x] Catchment vs. Number of due visits - https://reporting.avniproject.org/question/291 **Note: Visualizations in for comparison will not have any effect on the sector and Phulwari filter.

[garimadosar5]

QA Notes -

• Start and end date filter is working on WFA grade report also. Please check if it is filtering the right data. If so, then we can remove the select month and year filter. No its not filtering data on Start or end dates. It filters only on Month & year. Please check again.

[nupoorkhandelwal]