Show Chart

Last Saved By Ona
Owners [Ona ]
Tags []
Table cambodia_domain2_data
Created By Ona
Changed By Ona
Uuid 8270f5e3-0c00-f11b-0e58-bc783bba908b
Created On 2021-11-22 15:38:53.750226
Changed On 2021-11-22 15:38:55.934257
Name Percentage of justice professionals who have been certified and deal with a. child offenders b. child victims
Datasource Id 41
Datasource Type table
Datasource Name cambodia_domain2_data
Visualization Type table
Parameters {"adhoc_filters": [], "align_pn": false, "all_columns": [], "color_pn": true, "datasource": "41__table", "granularity_sqla": null, "groupby": ["province"], "include_search": false, "include_time": false, "metrics": [{"aggregate": "SUM", "column": {"column_name": "judges_male", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1216, "is_dttm": false, "optionName": "_col_judges_male", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "judges_m", "optionName": "metric_xeiqqp0jxkj_1w58p25fmp9", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "judges_f", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1217, "is_dttm": false, "optionName": "_col_judges_f", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "judges_f", "optionName": "metric_mpnifrkpdcl_crewj40yyw9", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "prosecuters_m", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1218, "is_dttm": false, "optionName": "_col_prosecuters_m", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "prosecuters_m", "optionName": "metric_so2j1lrubkh_g6agq73uqlq", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "prosecutors_f", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1219, "is_dttm": false, "optionName": "_col_prosecutors_f", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "prosecutors_f", "optionName": "metric_qoouveu4wer_i2hvidyxdar", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "defence_layers_m", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1220, "is_dttm": false, "optionName": "_col_defence_layers_m", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "defence_layers_m", "optionName": "metric_a4yk5wz8ouj_l1av1jkdy8", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "defence_layers_f", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1221, "is_dttm": false, "optionName": "_col_defence_layers_f", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "defence_layers_f", "optionName": "metric_i9c1be37b3_qe3mbqzmss", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "legal_aid_m", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1222, "is_dttm": false, "optionName": "_col_legal_aid_m", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "legal_aid_m", "optionName": "metric_wcmsy78j55_ir7ixwjrnm", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "legal_aid_f", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1223, "is_dttm": false, "optionName": "_col_legal_aid_f", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "legal_aid_f", "optionName": "metric_iu7u5erzs9a_iy2eatxt4u", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "police_m", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1224, "is_dttm": false, "optionName": "_col_police_m", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "police_m", "optionName": "metric_wdcc6z7dzgo_a8hh21vnn4u", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "police_f", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1227, "is_dttm": false, "optionName": "_col_police_f", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "police_f", "optionName": "metric_yxuxpse0n6_twivnx8pi5f", "sqlExpression": null}, {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "percent", "optionName": "metric_c79862r62d8_4nl73hrj5h9", "sqlExpression": "SUM(judges_male)/SUM(judges_f)"}], "order_by_cols": [], "order_desc": true, "page_length": 0, "percent_metrics": [], "row_limit": 10000, "slice_id": 1120, "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].[cambodia_domain2_data](id:41)
Schema Perm None
Last Saved At 2021-11-22 15:38:55.934257
Certified By None
Certification Details None
Is Managed Externally False
External Url None
Dashboards []
Report Schedules []