Show Chart

Last Saved By Ona
Owners [Ona ]
Tags []
Table indicator5_6_cdhs_data_updated
Created By Ona
Changed By Ona
Uuid 0655ef2f-36cc-4bd9-ea01-56c13b68c040
Created On 2021-11-22 11:50:02.729236
Changed On 2021-11-22 11:50:02.729247
Name Percentage of children under 18 not living with their biological parents despite having at least one parent alive by residence
Datasource Id 65
Datasource Type table
Datasource Name indicator5_6_cdhs_data_updated
Visualization Type pie
Parameters {"adhoc_filters": [{"clause": "WHERE", "comparator": "Residence", "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"}], "color_scheme": "bnbColors", "database_name": "UNICEF Cambodia", "datasource": "1758__table", "datasource_name": "indicator5_6_cdhs_data_updated", "donut": true, "granularity_sqla": "year", "groupby": ["category_value"], "import_time": 1637581598, "label_type": "key_value", "labels_outside": true, "metric": {"aggregate": "SUM", "column": {"column_name": "children_not_living_with_a_biological_parent", "database_expression": null, "description": null, "expression": "", "filterable": false, "groupby": false, "id": 43616, "is_dttm": false, "optionName": "_col_children_not_living_with_a_biological_parent", "python_date_format": null, "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "Children", "optionName": "metric_pzbb3qsn8fk_hitjdbtlg2b", "sqlExpression": null}, "remote_id": 4729, "row_limit": 10000, "schema": "", "show_labels": true, "show_legend": false, "time_grain_sqla": "P1D", "time_range": "No filter", "url_params": {}, "viz_type": "pie"}
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.729247
Certified By None
Certification Details None
Is Managed Externally False
External Url None
Dashboards [Dashboard<31>]
Report Schedules []