Show Chart

Last Saved By Ona
Owners [Ona ]
Tags []
Table indicator5_6_cdhs_data_updated
Created By Ona
Changed By Ona
Uuid 4466521e-48ea-c90a-3e8b-4aee94df9f87
Created On 2021-11-22 11:50:02.495485
Changed On 2021-12-29 08:07:35.016935
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", "url_params": {}, "viz_type": "dist_bar", "x_axis_label": "", "x_ticks_layout": "auto", "y_axis_format": ",.1%", "y_axis_label": ""}
Query Context None
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[indicator5_6_cdhs_data_updated](id:65)
Schema Perm None
Last Saved At 2021-12-29 08:07:35.016935
Certified By None
Certification Details None
Is Managed Externally False
External Url None
Dashboards [Dashboard<31>]
Report Schedules []