| Parameters |
{"adhoc_filters": [], "align_pn": false, "all_columns": [], "color_pn": true, "datasource": "56__table", "granularity_sqla": null, "groupby": ["province"], "include_search": false, "include_time": false, "metrics": [{"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "total_primary", "optionName": "metric_ol4i40s3pj_1o26p9oahpn", "sqlExpression": "SUM(cambodia_extracted_quantitative_data.total_teachers_primary_schools)"}, {"aggregate": "SUM", "column": {"column_name": "total_teachers_female", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1355, "is_dttm": false, "optionName": "_col_total_teachers_female", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "total_female", "optionName": "metric_atnlyc2s8bl_103qmgsvpmfd", "sqlExpression": null}, {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "total_male", "optionName": "metric_czp9o6iqyi4_0ze9t9z0beql", "sqlExpression": "SUM(total_teachers_primary_schools) - SUM(total_teachers_female)"}, {"aggregate": "SUM", "column": {"column_name": "teachers_trained_in_positive_discipline_Total", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1356, "is_dttm": false, "optionName": "_col_teachers_trained_in_positive_discipline_Total", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "total_trained", "optionName": "metric_n4fil515c7g_4xgkwey07oi", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "teachers_trained_in_positive_discipline_Female", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1357, "is_dttm": false, "optionName": "_col_teachers_trained_in_positive_discipline_Female", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "female_trained", "optionName": "metric_nwor4kj4rge_b52mtc37q76", "sqlExpression": null}, {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "male_trained", "optionName": "metric_67ko5tr3905_jj3dbbsm4h", "sqlExpression": "SUM(\"teachers_trained_in_positive_discipline_Total\")-SUM(\"teachers_trained_in_positive_discipline_Female\")"}, {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "percentage_trained", "optionName": "metric_yh9pnxqgkjn_e02lu7dd83k", "sqlExpression": "ROUND((SUM(\"teachers_trained_in_positive_discipline_Total\")/SUM(total_teachers_primary_schools)) * 100)"}], "order_by_cols": [], "order_desc": true, "page_length": 0, "percent_metrics": [], "row_limit": 10000, "slice_id": 1152, "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"}
|
