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": "total_buget", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1228, "is_dttm": false, "optionName": "_col_total_buget", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "total_budget", "optionName": "metric_phijre8x1u7_va89qgd446r", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "actual_expense", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1229, "is_dttm": false, "optionName": "_col_actual_expense", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "actual_expenses", "optionName": "metric_xvu6slhq8a9_bijau71eg2v", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "total_bdgt_for_ss", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1230, "is_dttm": false, "optionName": "_col_total_bdgt_for_ss", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "total_bdgt_ss", "optionName": "metric_cp6antt0n6w_ymvnli15b0e", "sqlExpression": null}, {"aggregate": "SUM", "column": {"column_name": "actual_expe_for_ss", "description": null, "expression": "", "filterable": false, "groupby": false, "id": 1231, "is_dttm": false, "optionName": "_col_actual_expe_for_ss", "type": "DOUBLE PRECISION", "verbose_name": null}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "actual_exp_ss", "optionName": "metric_ddbzkg560s_s9jin9xflqr", "sqlExpression": null}, {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "percentage_total_bdg_to_ss", "optionName": "metric_jrkucu566xr_95csfk6wyli", "sqlExpression": "ROUND((SUM(total_bdgt_for_ss)/SUM(total_buget))*100)"}, {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "per_exp_ss", "optionName": "metric_ud8tnbw6ks_buhik5axjkp", "sqlExpression": "Round((SUM(actual_expe_for_ss)/SUM(actual_expense))*100)"}], "order_by_cols": [], "order_desc": true, "page_length": 0, "percent_metrics": [], "row_limit": 10000, "slice_id": 1119, "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"}
|