Show Chart

Owners [Ona ]
Created By Ona
Changed By Ona
Created On 2022-01-18 12:27:29.981562
Changed On 2022-01-19 07:46:04.108204
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": 706, "datasource_name": "indicator5_6_cdhs_data_updated", "schema": null, "database_name": "UNICEF Cambodia", "import_time": 1642578313}
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[indicator5_6_cdhs_data_updated](id:65)
Schema Perm None
Dashboards [Cambodia Child Protection Profile 2018 - TEST, Cambodia Child Protection Profile 2018 - TEST2]
Email Schedules []