Show Chart

Last Saved By Ona
Owners [Ona ]
Tags []
Table indicator5_6_cdhs_data_updated
Created By Ona
Changed By Ona
Uuid 3dbc7ff2-225c-890f-e4a6-6e74609a6b72
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}
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-11-22 11:50:02.579498
Certified By None
Certification Details None
Is Managed Externally False
External Url None
Dashboards [Dashboard<31>]
Report Schedules []