| Parameters |
{"adhoc_filters": [{"clause": "WHERE", "comparator": null, "expressionType": "SQL", "filterOptionName": "filter_57fh6fcs5hk_ng8zg9xh38j", "fromFormData": true, "operator": null, "sqlExpression": "activity <> 'Total budget for child protection' AND activity <> 'Total budget for development' AND activity <> '% of NGOs budget for child protection'", "subject": null}], "bar_stacked": false, "bottom_margin": "5", "color_scheme": "bnbColors", "columns": [], "contribution": false, "datasource": "99__table", "granularity_sqla": null, "groupby": ["activity"], "label_colors": {"2015": "#7b0051", "2018": "#007A87", "RCIs": "#ff5a5f", "Total Budget": "#00d1c1"}, "metrics": [{"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Total Budget", "optionName": "metric_17jtvub6zmv_z6nmr9gl8i", "sqlExpression": "ROUND(SUM(\"Total \" ))"}], "order_bars": false, "reduce_x_ticks": false, "row_limit": 10000, "show_bar_value": false, "show_controls": false, "show_legend": false, "slice_id": 668, "time_range": "Last week", "url_params": {}, "viz_type": "dist_bar", "x_axis_label": "", "x_ticks_layout": "auto", "y_axis_format": ",", "y_axis_label": "", "remote_id": 668, "datasource_name": "indicator2_6_data", "schema": null, "database_name": "UNICEF Cambodia", "import_time": 1642578313}
|
| Query Context |
{"datasource":{"id":99,"type":"table"},"force":false,"queries":[{"time_range":"Last week","granularity":null,"filters":[],"extras":{"having":"","where":"(activity <> 'Total budget for child protection' AND activity <> 'Total budget for development' AND activity <> '% of NGOs budget for child protection')"},"applied_time_extras":{},"columns":["activity"],"metrics":[{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"Total Budget","optionName":"metric_17jtvub6zmv_z6nmr9gl8i","sqlExpression":"ROUND(SUM(\"Total \" ))"}],"annotation_layers":[],"row_limit":10000,"series_limit":0,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{}}],"form_data":{"adhoc_filters":[{"clause":"WHERE","comparator":null,"expressionType":"SQL","filterOptionName":"filter_57fh6fcs5hk_ng8zg9xh38j","fromFormData":true,"operator":null,"sqlExpression":"activity <> 'Total budget for child protection' AND activity <> 'Total budget for development' AND activity <> '% of NGOs budget for child protection'","subject":null}],"bar_stacked":false,"bottom_margin":"5","color_scheme":"bnbColors","columns":[],"contribution":false,"database_name":"UNICEF Cambodia","datasource":"99__table","datasource_name":"indicator2_6_data","granularity_sqla":null,"groupby":["activity"],"import_time":1642578313,"label_colors":{"2015":"#7b0051","2018":"#007A87","RCIs":"#ff5a5f","Total Budget":"#00d1c1"},"metrics":[{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"Total Budget","optionName":"metric_17jtvub6zmv_z6nmr9gl8i","sqlExpression":"ROUND(SUM(\"Total \" ))"}],"order_bars":false,"reduce_x_ticks":false,"remote_id":668,"row_limit":10000,"schema":null,"show_bar_value":false,"show_controls":false,"show_legend":false,"slice_id":2226,"time_range":"Last week","url_params":{},"viz_type":"dist_bar","x_axis_label":"","x_ticks_layout":"auto","y_axis_format":",","y_axis_label":"","force":false,"result_format":"json","result_type":"full"},"result_format":"json","result_type":"full"}
|
