| Parameters |
{"adhoc_filters": [{"clause": "WHERE", "comparator": "1", "expressionType": "SIMPLE", "filterOptionName": "filter_17tn287oc03_du8qeufrvvk", "fromFormData": true, "isExtra": false, "operator": "==", "sqlExpression": null, "subject": "level"}], "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": "mothers", "optionName": "metric_y48ewdkrs7_zv12lnwm1y", "sqlExpression": "SUM(case when cambodia_extracted_quantitative_data.number_of_mothers_reached is null then 0 else cambodia_extracted_quantitative_data.number_of_mothers_reached end::numeric)"}, {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "fathers", "optionName": "metric_m7f4d2pxxz_rckpm95fdt", "sqlExpression": "SUM(case when number_of_fathers_reached is null then 0 else number_of_fathers_reached end::numeric)"}, {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "caregivers", "optionName": "metric_h4m05byhtcv_6sv9u9qfs3g", "sqlExpression": "SUM(case when number_of_caregivers_reached is null then 0 else number_of_caregivers_reached end::numeric)"}, {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "total", "optionName": "metric_11gj7t6swb4_xar50vn11h", "sqlExpression": "SUM(case when cambodia_extracted_quantitative_data.total is null then 0 else cambodia_extracted_quantitative_data.total end::numeric )"}], "order_by_cols": [], "order_desc": true, "page_length": 0, "percent_metrics": [], "row_limit": 10000, "slice_id": 1135, "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"}
|
