Show Chart

Last Saved By Ona
Owners [Ona ]
Tags []
Table indicator5_6_cdhs_data_updated
Created By Ona
Changed By Ona
Uuid 3950b59c-1cdf-a5b3-7983-8f4e96c36ccb
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", "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}
Query Context None
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[indicator5_6_cdhs_data_updated](id:65)
Schema Perm None
Last Saved At 2022-01-19 07:46:04.052773
Certified By None
Certification Details None
Is Managed Externally False
External Url None
Dashboards [Dashboard<38>, Dashboard<41>]
Report Schedules []