Skip to content

Metabase Report

garimadosar5 edited this page May 6, 2019 · 20 revisions

Following is the list of all the reports provided -

  1. All Children

  2. Due Visits

  3. Faltering Children

  4. List of Children - weight not taken

  5. New children enrolled in Phulwari in a month

  6. Phulwari child weight gain (Enrolled Children)

  7. Population Standard

  8. Sync Report

  9. Weight for Age Grade - Phulwari Children

All Children

Purpose of the report:

Title of Report in Metabase:

Columns (along with logic for columns except for the basic ones):

Column Description
Name
Age
Registration Date
Enrolment Date
Exit Date
Catchment
Village
Phulwari
Gender
Time since enrolment
Visit done
Age>=6 months
First Weight
First WFA grade
Last weight
Last WFA grade
IndividualId

Filters:

No Filter

Logic for data:

Due Visits

Purpose of the report:

Title of Report in Metabase:

Columns (along with logic for columns except for the basic ones):

Column Description
Name
Age
Enrolment Date
Catchment
Village
Phulwari
Gender
Visit Type
Visit Name
IndividualId

Filters:

Visit Type:

Logic for data:

Faltering Children

Purpose of the report:

Title of Report in Metabase:

Columns (along with logic for columns except for the basic ones):

Column Description
Cathment
Village
Phulwari
Full Name
Age
Gender
Father's Name
Recent Encounter date
Recent WFA grade
Recent WFA Zscore
Recent WFA status
Enrolment Date
Time since Enrolment
IndividualId

Filters:

Start Date and End Date :

Catchment name:

Logic for data:

Line list of children - weight not taken

Purpose of the report:

Title of Report in Metabase:

Columns (along with logic for columns except for the basic ones):

Column Description
Catchment
Village
Phulwari
Full Name
Mother's Name
Father's Name
DOB
Age
Gender
Last weight taken date
Time since last weight taken
Registration Date
Enrolment Date
IndividualId

Filters:

Catchment name:

Start Date:

Logic for data:

New children enrolled in Phulwari in a month

Purpose of the report:

Title of Report in Metabase:

Columns (along with logic for columns except for the basic ones):

Column Description

Filters:

Logic for data:

Phulwari child weight gain (Enrolled Children)

Purpose of the report:

Title of Report in Metabase:

Columns (along with logic for columns except for the basic ones):

Column Description

Filters:

Logic for data:

Population Standard

Purpose of the report:

Title of Report in Metabase:

Columns (along with logic for columns except for the basic ones):

Column Description

Filters:

Logic for data:

Sync Report

Purpose of the report:

Title of Report in Metabase:

Columns (along with logic for columns except for the basic ones):

Column Description

Filters:

Logic for data:

Weight for Age Grade - Phulwari Children

Purpose of the report:

Title of Report in Metabase:

Columns (along with logic for columns except for the basic ones):

Column Description

Filters:

Logic for data:

Clone this wiki locally