| Parameters |
{"adhoc_filters": [{"clause": "WHERE", "comparator": null, "expressionType": "SQL", "filterOptionName": "filter_e7lybhc7eq9_707xhi1cwwp", "fromFormData": true, "operator": null, "sqlExpression": "\"Sector\" IS NOT NULL AND \"Sector\" <> 'Total donors budget for development'", "subject": null}], "color_scheme": "bnbColors", "database_name": "UNICEF Cambodia", "datasource": "1728__table", "datasource_name": "indicator2_6_disagg_data", "donut": true, "granularity_sqla": null, "groupby": ["Sector"], "import_time": 1637581598, "label_type": "key_percent", "labels_outside": true, "metric": {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Percent", "optionName": "metric_a6mx6p7z0ri_3ohgcud1vmn", "sqlExpression": "ROUND(SUM(\"Total Budget\")/1263422780 * 100)"}, "remote_id": 4695, "row_limit": 10000, "schema": "", "show_labels": true, "show_legend": false, "slice_id": 4366, "time_grain_sqla": "P1D", "time_range": "Last week", "url_params": {}, "viz_type": "pie"}
|
| Query Context |
{"datasource":{"id":96,"type":"table"},"force":false,"queries":[{"time_range":"Last week","granularity":null,"filters":[],"extras":{"time_grain_sqla":"P1D","having":"","where":"(\"Sector\" IS NOT NULL AND \"Sector\" <> 'Total donors budget for development')"},"applied_time_extras":{},"columns":["Sector"],"metrics":[{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"Percent","optionName":"metric_a6mx6p7z0ri_3ohgcud1vmn","sqlExpression":"ROUND(SUM(\"Total Budget\")/1263422780 * 100)"}],"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_e7lybhc7eq9_707xhi1cwwp","fromFormData":true,"operator":null,"sqlExpression":"\"Sector\" IS NOT NULL AND \"Sector\" <> 'Total donors budget for development'","subject":null}],"color_scheme":"bnbColors","database_name":"UNICEF Cambodia","datasource":"96__table","datasource_name":"indicator2_6_disagg_data","donut":true,"granularity_sqla":null,"groupby":["Sector"],"import_time":1637581598,"label_type":"key_percent","labels_outside":true,"metric":{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"Percent","optionName":"metric_a6mx6p7z0ri_3ohgcud1vmn","sqlExpression":"ROUND(SUM(\"Total Budget\")/1263422780 * 100)"},"remote_id":4695,"row_limit":10000,"schema":"","show_labels":true,"show_legend":false,"slice_id":674,"time_grain_sqla":"P1D","time_range":"Last week","url_params":{},"viz_type":"pie","force":false,"result_format":"json","result_type":"full"},"result_format":"json","result_type":"full"}
|
