User confirmation needed
Sources
Databases
Tables
Charts
Dashboards
- Italian
- French
- Chinese
- Japanese
- German
- Russian
- Portuguese
- Brazilian Portuguese
Login
Edit Chart
Detail
Name
Description
The content here can be displayed as widget headers in the dashboard view. Supports
markdown
Visualization Type
Owners
Angela Kabari
Emily Nguyen
Kelvin Jayanoris
alex kahure
Phearak RIN
Su Myat Lwin
Vanthea Mao
Sovath Ngin
Janette Wambere
Ukang'a Dickson
Juanita Escallon
Faith
Training User
Brian Cheye
Ona Admin
MCO ICT
Client Forms
Ona
Paper Scissors
Matt Berg
Khin Moe Aye
Bella Okiddy
Thazin Maung
Bilhah Kimondiu
Khin Mon Nyein
Jonathan Munene
Alessandro Pietrobon
phanneth khauv
Mee Mee Thaw
Sophy Thea
Fawzia Hoodbhoy
George Kamau
Samson
Dashboards
ស្ថិតិស្តីពីកិច្ចការពារកុមារនៅកម្ពុជា ឆ្នាំ២០១៨
ផ្ទាំងទិន្នន័យសង្ខេប
Summary Dashboard
Cambodia Child Protection Profile 2018
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.
Save