{APF Dashboard Report} : Household Entitlement

avniproject / apfodishanutrition

GNU Affero General Public License v3.0

0 stars 0 forks source link

{APF Dashboard Report} : Household Entitlement #198

Open kameshbhariya opened 3 months ago

kameshbhariya commented 3 months ago

[x] Make the report in the pre-release.
[x] Household Entitlement Reports are a new report to be added for the client in superset. It is being used to track the social security entitlements of households.
[x] The report needs to have a total count of the social security entitlements of households, in a bar graph.
[x] An aggregate report and linelist depicting the complete details of the household should be displayed. The detailed requirements are available in the analysis link shared below.
[x] It will have filters for filtering the data based on the following: 1. Project/Block 2. Sector
[x] Link to the analysis

adamsanadi6 commented 3 months ago

Dashboard link: [APFODISHA Prerelease] Household Entitlements

adamsanadi6 commented 3 months ago

@vedfordev Please do the code review select h.id as "House Id", h.registration_date as "Registration date", h.first_name as "Household name", h."Social security entitlements" as "Entitlements", unnest(string_to_array(h."Social security entitlements", ', ')) AS "Entitlement", h."Number of members in the family" as "Number of family members", awc."Sector", village."Block" from apfodisha.household h left join apfodisha.address awc on awc.uuid = h."AWC Name" and awc.is_voided = false left join apfodisha.address village on village.id = h.address_id and village.is_voided = false where h.is_voided = false

vedfordev commented 1 month ago

Rework:

As discussed with @kameshbhariya Added village type filter,registration date filter and entitlement filter. And no need to create separate linelist

Dinesh2019 commented 1 month ago

[ ] Exit status is missing in the column
[x] The village type is missing in the line list column.
[x] Need to add the header for all PPK, PVTG, and Geographical risks,s and also we need to add those filters to aggregate.
[x] Add those columns to the line list.

vedfordev commented 1 month ago

@Dinesh2019 Exit will not require as this is about subject only no program involve. @kameshbhariya remove exit status

kameshbhariya commented 1 month ago

@vedfordev @Dinesh2019 Removed exit status from this report.