Show Chart

Owners [Ona ]
Created By Ona
Changed By Ona
Created On 2022-01-18 12:27:29.909029
Changed On 2022-01-19 07:46:04.052773
Name Percentage of children under 18 not living with their biological parents despite having at least one parent alive per province
Datasource Id 65
Datasource Type table
Datasource Name indicator5_6_cdhs_data_updated
Visualization Type dist_bar
Parameters {"adhoc_filters": [{"clause": "WHERE", "comparator": "Province", "expressionType": "SIMPLE", "filterOptionName": "filter_eaaaqun7ve9_4klrpkbvlwl", "fromFormData": true, "operator": "==", "sqlExpression": null, "subject": "category"}, {"clause": "WHERE", "comparator": "2014", "expressionType": "SIMPLE", "filterOptionName": "filter_awkpb080io_82ssa9sjrc", "fromFormData": true, "operator": "==", "sqlExpression": null, "subject": "year"}], "bar_stacked": false, "bottom_margin": "auto", "color_scheme": "bnbColors", "columns": [], "contribution": false, "datasource": "65__table", "granularity_sqla": "year", "groupby": ["category_value"], "label_colors": {"0-1 Years": "#007A87", "2-4 Years": "#7b0051", "2015": "#b37e00", "2015 Children:": "#00b3a5", "2016": "#bbedab", "2017": "#ffd266", "2018": "#988b4e", "2018 Children:": "#55d12e", "Agriculture": "#8ce071", "Both alive": "#cbc29a", "Budget": "#007A87", "Business and financial services": "#cbc29a", "Child Rape": "#ff3339", "Children": "#ffd266", "Children:": "#00d1c1", "Climate change and environment": "#bbedab", "Community and social welfare, including child protection": "#ff3339", "Culture, arts and sports": "#ffd266", "EU/EC": "#b37e00", "Education": "#b4a76c", "Energy power and electricity": "#ff8083", "Father alive": "#ff3339", "Female": "#ff8083", "Forster and/or Orphans": "#ff5a5f", "Foster": "#7b0051", "Governance and gender": "#cc0086", "Health and HIV and AIDS": "#ffb400", "Human trafficking": "#ff1ab1", "Level 1": "#00a1b3", "Level 2": "#00ffeb", "Male": "#b4a76c", "Mother alive": "#ff1ab1", "No disability or difficulty": "#8ce071", "Not biological parent": "#00b3a5", "Not living with biological parent": "#005c66", "Others (Tourism, industralisation, ICT, trade)": "#ff1ab1", "Percentage": "#00d1c1", "RCIs": "#ff5a5f", "Registered": "#bbedab", "Registred": "#cc0086", "Rural": "#ffb400", "Rural development": "#00ffeb", "Sexual exploitation": "#005c66", "Single Orphans": "#007A87", "Some difficulty": "#ffb400", "Total": "#cbc29a", "Total Budget": "#7b0051", "Total CP Budget": "#ff5a5f", "Transportation": "#00d1c1", "UNDP": "#988b4e", "UNICEF": "#00b3a5", "USAID": "#55d12e", "Urban": "#8ce071", "Urban planning": "#005c66", "Water and sanitation": "#00a1b3", "With Birth Certificate": "#00a1b3", "Without Birth Certificate": "#00ffeb", "a lot of difficulty or cannot do": "#b4a76c", "level1": "#ff8083", "level2": "#cc0086"}, "metrics": [{"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Not living with biological parent", "optionName": "metric_g5rhz44bqja_tpmclkbz08f", "sqlExpression": "SUM(children_not_living_with_a_biological_parent)/100"}, {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Both alive", "optionName": "metric_4wmj9asc3e4_mxg90xn725q", "sqlExpression": "SUM(children_living_with_neither_parent_both_alive)/100"}, {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Father alive", "optionName": "metric_xptr5t9qxg_yueevmb8w3h", "sqlExpression": "SUM(children_living_with_neither_parent_father_alive)/100"}, {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Mother alive", "optionName": "metric_exwijtivln_pdnlr8jo3po", "sqlExpression": "SUM(children_living_with_neither_parent_mother_alive)/100"}], "order_bars": false, "reduce_x_ticks": true, "row_limit": 10000, "show_bar_value": false, "show_controls": false, "show_legend": true, "slice_id": 705, "time_range": "No filter", "time_range_endpoints": ["unknown", "inclusive"], "url_params": {}, "viz_type": "dist_bar", "x_axis_label": "", "x_ticks_layout": "auto", "y_axis_format": ",.1%", "y_axis_label": "", "remote_id": 705, "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 []