| Parameters |
{"adhoc_filters": [], "align_pn": false, "all_columns": [], "color_pn": true, "datasource": "184__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_care", "optionName": "metric_wo2gota8y4a_oyvwcai9by", "sqlExpression": "SUM(case when all_care is null then 0 else all_care end::NUMERIC)"}, {"aggregate": "SUM", "column": {"column_name": "rci", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 2265, "is_dttm": false, "optionName": "_col_rci", "type": "BIGINT", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "rci", "optionName": "metric_mi3xcridcnd_ttkxu7l35c", "sqlExpression": null}, {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "gh", "optionName": "metric_r5zypkt2ne8_klsae8fqf3", "sqlExpression": "SUM(case when gh is null then 0 else gh end::NUMERIC)"}, {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "bs", "optionName": "metric_tw40oseqq1n_i59f1oe4m3", "sqlExpression": "SUM(case when bs is null then 0 else bs end::NUMERIC)"}, {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "pagoda", "optionName": "metric_s065l4hdb8h_ogm1lm1iewi", "sqlExpression": "SUM(case when pagoda is null then 0 else pagoda end::NUMERIC)"}, {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "th", "optionName": "metric_1cgnbe5d715_i0zy35zalb", "sqlExpression": "SUM(case when th is null then 0 else th end::NUMERIC)"}], "order_by_cols": [], "order_desc": true, "page_length": 0, "percent_metrics": [], "row_limit": 10000, "slice_id": 1126, "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"}
|
