UNICEF Cambodia Discover

Edit Chart

Name
Description	The content here can be displayed as widget headers in the dashboard view. Supports markdown
Visualization Type
Owners
Dashboards
Parameters	{ "adhoc_filters": [], "align_pn": false, "all_columns": [], "color_pn": true, "datasource": "181__table", "granularity_sqla": null, "groupby": [ "province" ], "include_search": false, "include_time": false, "metrics": [ { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "all_total", "optionName": "metric_v9fuc4ltqz_1g2dpy7dbo1i", "sqlExpression": "SUM(case when all_total is null then 0 else all_total end::NUMERIC)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "all_male", "optionName": "metric_16zu0pot652_z5g3c44oue", "sqlExpression": "SUM(case when all_male is null then 0 else all_male end::numeric)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "all_female", "optionName": "metric_pm26ghn6z2b_xt0fagfvra", "sqlExpression": "SUM(case when all_female is null then 0 else all_female end::numeric)" }, { "aggregate": "SUM", "column": { "column_name": "total_rci", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 2240, "is_dttm": false, "optionName": "_col_total_rci", "type": "BIGINT", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "total_rci", "optionName": "metric_jwyrro4zome_q831cmnt4hc", "sqlExpression": null }, { "aggregate": "SUM", "column": { "column_name": "male_rci", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 2241, "is_dttm": false, "optionName": "_col_male_rci", "type": "BIGINT", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "male_rci", "optionName": "metric_lu4tg5yhkv9_yjo1o5g1muo", "sqlExpression": null }, { "aggregate": "SUM", "column": { "column_name": "female_rci", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 2242, "is_dttm": false, "optionName": "_col_female_rci", "type": "BIGINT", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "female_rci", "optionName": "metric_fne7j4lmsrs_yopprkgdre", "sqlExpression": null }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "total_gh", "optionName": "metric_brsu8naohk_rg9dg4oxe2", "sqlExpression": "SUM(case when total_gh is null then 0 else total_gh end::numeric)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "male_gh", "optionName": "metric_ae8per2655n_iwl3n422ai8", "sqlExpression": "SUM(case when male_gh is null then 0 else male_gh end::numeric)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "female_gh", "optionName": "metric_v4mbgfwz5q_y4xsb1zm6h", "sqlExpression": "SUM(case when female_gh is null then 0 else female_gh end::numeric)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "total_bs", "optionName": "metric_nnv13hnw62o_4gnfhcnn5ua", "sqlExpression": "SUM(case when total_bs is null then 0 else total_bs end::NUMERIC)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "male_bs", "optionName": "metric_ak5h9yu0j3_se3eqx2t2q", "sqlExpression": "SUM(case when male_bs is null then 0 else male_bs end::numeric)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "female_bs", "optionName": "metric_guyo08ed7se_mycd41tz8dh", "sqlExpression": "SUM(case when female_bs is null then 0 else female_bs end::numeric)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "total_pagado", "optionName": "metric_eoq2ecbou2_t2xlqipcrcq", "sqlExpression": "SUM(case when total_pagoda is null then 0 else total_pagoda end::NUMERIC)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "male_pagado", "optionName": "metric_wpjcwg774r8_xyg0nf65wr", "sqlExpression": "SUM(case when male_pagoda is null then 0 else male_pagoda end::NUMERIC)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "female_pagado", "optionName": "metric_zqx4b3yn2mg_iysys5yjyp", "sqlExpression": "SUM(case when female_pagoda is null then 0 else female_pagoda end::NUMERIC)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "total_th", "optionName": "metric_polggweotdi_1ndffmdi1t0h", "sqlExpression": "SUM(case when total_th is null then 0 else total_th end::NUMERIC)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "female_th", "optionName": "metric_nj5rqlhyuoi_30myjkwcbij", "sqlExpression": "SUM(case when female_th is null then 0 else female_th end::numeric)" }, { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "male_th", "optionName": "metric_mlp5f5igt6_d8msw56h8e8", "sqlExpression": "SUM(case when male_th is null then 0 else male_th end::NUMERIC)" } ], "order_by_cols": [], "order_desc": true, "page_length": 0, "percent_metrics": [], "row_limit": 10000, "slice_id": 1117, "table_filter": false, "table_timestamp_format": "%Y-%m-%d %H:%M:%S", "time_grain_sqla": "P1D", "time_range": "Last week", "time_range_endpoints": [ "inclusive", "exclusive" ], "timeseries_limit_metric": null, "url_params": {}, "viz_type": "table" } These parameters are generated dynamically when clicking the save or overwrite button in the explore view. This JSON object is exposed here for reference and for power users who may want to alter specific parameters.
Cache Timeout	Duration (in seconds) of the caching timeout for this chart. Note this defaults to the datasource/table timeout if undefined.