Show Chart

Owners [Ona ]
Created By Ona
Changed By Ona
Created On 2021-11-22 11:50:02.579487
Changed On 2021-11-22 11:50:02.579498
Name Percentage of children under 18 not living with their biological parents despite having at least one parent alive by age category
Datasource Id 65
Datasource Type table
Datasource Name indicator5_6_cdhs_data_updated
Visualization Type dist_bar
Parameters {"datasource": "1758__table", "viz_type": "dist_bar", "slice_id": 4727, "url_params": {}, "granularity_sqla": "year", "time_grain_sqla": "P1D", "time_range": "No filter", "metrics": [{"expressionType": "SQL", "sqlExpression": "SUM(children_not_living_with_a_biological_parent)/100", "column": null, "aggregate": null, "hasCustomLabel": true, "fromFormData": true, "label": "Not biological parent", "optionName": "metric_4t7nueg7meh_bhyeikx4bhk"}, {"expressionType": "SQL", "sqlExpression": "SUM(children_living_with_neither_parent_both_alive)/100", "column": null, "aggregate": null, "hasCustomLabel": true, "fromFormData": true, "label": "Both alive", "optionName": "metric_ph43m3nv7y8_wrpjkm1lcl"}, {"expressionType": "SQL", "sqlExpression": "SUM(children_living_with_neither_parent_mother_alive)/100", "column": null, "aggregate": null, "hasCustomLabel": true, "fromFormData": true, "label": "Mother alive", "optionName": "metric_01xygue9bigq_wgtcpezu3w8"}, {"expressionType": "SQL", "sqlExpression": "SUM(children_living_with_neither_parent_father_alive)/100", "column": null, "aggregate": null, "hasCustomLabel": true, "fromFormData": true, "label": "Father alive", "optionName": "metric_6jdmnioxias_vli76ngzoko"}], "adhoc_filters": [{"expressionType": "SIMPLE", "subject": "category", "operator": "==", "comparator": "Age", "clause": "WHERE", "sqlExpression": null, "fromFormData": true, "filterOptionName": "filter_fowfq9jpr4v_oxd3eqmcgro"}, {"expressionType": "SIMPLE", "subject": "year", "operator": "==", "comparator": "2014", "clause": "WHERE", "sqlExpression": null, "fromFormData": true, "filterOptionName": "filter_2tu5witu4x_qznx1wyzt0f"}, {"expressionType": "SQL", "sqlExpression": "category_value <> '0-1' AND category_value <> '2-4'", "clause": "WHERE", "subject": null, "operator": null, "comparator": null, "fromFormData": true, "filterOptionName": "filter_ykes6lbman_931143qcz8l"}], "groupby": ["category_value"], "columns": [], "row_limit": 10000, "contribution": false, "color_scheme": "bnbColors", "show_legend": true, "show_bar_value": false, "bar_stacked": false, "order_bars": true, "y_axis_format": ",.1%", "y_axis_label": "", "show_controls": false, "x_axis_label": "", "bottom_margin": "auto", "x_ticks_layout": "auto", "reduce_x_ticks": false, "remote_id": 4727, "datasource_name": "indicator5_6_cdhs_data_updated", "schema": "", "database_name": "UNICEF Cambodia", "import_time": 1637581598}
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[indicator5_6_cdhs_data_updated](id:65)
Schema Perm None
Dashboards [Cambodia Child Protection Profile 2018]
Email Schedules []