Show Chart

Last Saved By Ona
Owners [Ona ]
Tags []
Table public.indicator2_9_data
Created By Ona
Changed By Ona
Uuid e414acf5-4224-6371-c755-04a74ff5d5f1
Created On 2021-11-22 15:43:38.365975
Changed On 2021-11-22 15:43:43.118424
Name Number of formal family-based alternative care providers in the country (foster carers and formal kinship carers)
Datasource Id 182
Datasource Type table
Datasource Name public.indicator2_9_data
Visualization Type table
Parameters {"adhoc_filters": [], "align_pn": false, "all_columns": [], "color_pn": true, "datasource": "182__table", "granularity_sqla": null, "groupby": ["province"], "include_search": false, "include_time": false, "metrics": [{"aggregate": "SUM", "column": {"column_name": "all_providers", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 2256, "is_dttm": false, "optionName": "_col_all_providers", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "all_providers", "optionName": "metric_fa1ujbk0xnq_wvxq0evga39", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "foster_care", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 2257, "is_dttm": false, "optionName": "_col_foster_care", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "foster_care", "optionName": "metric_uz17cg3uw7_a46mmlguldv", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "formal_kinship_care", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 2258, "is_dttm": false, "optionName": "_col_formal_kinship_care", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "formal_kinship_care", "optionName": "metric_3mykqapyi1u_b936xv5jj8", "sqlExpression": null}], "order_by_cols": [], "order_desc": true, "page_length": 0, "percent_metrics": [], "row_limit": 10000, "slice_id": 1121, "table_filter": false, "table_timestamp_format": "%Y-%m-%d %H:%M:%S", "time_grain_sqla": "P1D", "time_range": "Last week", "timeseries_limit_metric": null, "url_params": {}, "viz_type": "table"}
Query Context None
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[indicator2_9_data](id:182)
Schema Perm [UNICEF Cambodia].[public]
Last Saved At 2021-11-22 15:43:43.118424
Certified By None
Certification Details None
Is Managed Externally False
External Url None
Dashboards []
Report Schedules []