Parameters |
{"adhoc_filters": [{"clause": "WHERE", "comparator": "Total Workers", "expressionType": "SIMPLE", "filterOptionName": "filter_6wznjyywfzd_pswt9f6edza", "fromFormData": true, "operator": "==", "sqlExpression": null, "subject": "level"}], "database_name": "UNICEF Cambodia", "datasource": "2633__table", "datasource_name": "domain_two_summary_table", "granularity_sqla": null, "import_time": 1637586045, "metric": {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": false, "label": "MAX(4252)", "optionName": "metric_lhiw9kdoo7f_cmlbflb6paq", "sqlExpression": "MAX(4252)"}, "remote_id": 13658, "schema": "summary", "slice_id": 13658, "subheader": "Total Workers", "time_grain_sqla": "P1D", "time_range": "Last week", "url_params": {}, "viz_type": "big_number_total", "y_axis_format": ","}
|
Query Context |
{"datasource":{"id":162,"type":"table"},"force":false,"queries":[{"time_range":"Last week","granularity":null,"filters":[{"col":"level","op":"==","val":"Total Workers"}],"extras":{"time_grain_sqla":"P1D","having":"","where":""},"applied_time_extras":{},"columns":[],"metrics":[{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":false,"label":"MAX(4252)","optionName":"metric_lhiw9kdoo7f_cmlbflb6paq","sqlExpression":"MAX(4252)"}],"annotation_layers":[],"series_limit":0,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{}}],"form_data":{"adhoc_filters":[{"clause":"WHERE","comparator":"Total Workers","expressionType":"SIMPLE","filterOptionName":"filter_6wznjyywfzd_pswt9f6edza","fromFormData":true,"operator":"==","sqlExpression":null,"subject":"level"}],"database_name":"UNICEF Cambodia","datasource":"162__table","datasource_name":"domain_two_summary_table","granularity_sqla":null,"import_time":1637586045,"metric":{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":false,"label":"MAX(4252)","optionName":"metric_lhiw9kdoo7f_cmlbflb6paq","sqlExpression":"MAX(4252)"},"remote_id":13658,"schema":"summary","slice_id":1105,"subheader":"Total Workers","time_grain_sqla":"P1D","time_range":"Last week","url_params":{},"viz_type":"big_number_total","y_axis_format":",","force":false,"result_format":"json","result_type":"full"},"result_format":"json","result_type":"full"}
|