Parameters |
{"adhoc_filters": [{"clause": "WHERE", "comparator": ["Physical violence", "Emotional violence", "Sexual exploitation and abuse (including online)", "Neglect", "Abandonment", "Street child", "Migrant child", "Child with mental health", "Child labour", "Injured", "Living in residential care", "Alternative care", "Missing child", "Drug", "Trafficking"], "expressionType": "SIMPLE", "filterOptionName": "filter_ptcq7qg3bsn_jfzho0rtx9t", "fromFormData": true, "operator": "in", "sqlExpression": null, "subject": "item"}], "bar_stacked": false, "bottom_margin": "5", "color_scheme": "bnbColors", "columns": [], "contribution": false, "datasource": "97__table", "granularity_sqla": null, "groupby": ["item"], "label_colors": {"Children:": "#00d1c1", "Female": "#ff5a5f", "Male": "#7b0051", "Total": "#007A87"}, "metrics": [{"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Children:", "optionName": "metric_5zz4ts5sh1a_d92dogwec19", "sqlExpression": "SUM(coalesce(\"Counselling_L\",0))"}], "order_bars": false, "reduce_x_ticks": true, "row_limit": 10000, "show_bar_value": false, "show_controls": false, "show_legend": false, "slice_id": 567, "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": 567, "datasource_name": "4_1_indicator_summary", "schema": "", "database_name": "UNICEF Cambodia", "import_time": 1642578313}
|
Query Context |
{"datasource":{"id":97,"type":"table"},"force":false,"queries":[{"time_range":"Last week","granularity":null,"filters":[{"col":"item","op":"in","val":["Physical violence","Emotional violence","Sexual exploitation and abuse (including online)","Neglect","Abandonment","Street child","Migrant child","Child with mental health","Child labour","Injured","Living in residential care","Alternative care","Missing child","Drug","Trafficking"]}],"extras":{"having":"","where":""},"applied_time_extras":{},"columns":["item"],"metrics":[{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"Children:","optionName":"metric_5zz4ts5sh1a_d92dogwec19","sqlExpression":"SUM(coalesce(\"Counselling_L\",0))"}],"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":["Physical violence","Emotional violence","Sexual exploitation and abuse (including online)","Neglect","Abandonment","Street child","Migrant child","Child with mental health","Child labour","Injured","Living in residential care","Alternative care","Missing child","Drug","Trafficking"],"expressionType":"SIMPLE","filterOptionName":"filter_ptcq7qg3bsn_jfzho0rtx9t","fromFormData":true,"operator":"in","sqlExpression":null,"subject":"item"}],"bar_stacked":false,"bottom_margin":"5","color_scheme":"bnbColors","columns":[],"contribution":false,"database_name":"UNICEF Cambodia","datasource":"97__table","datasource_name":"4_1_indicator_summary","granularity_sqla":null,"groupby":["item"],"import_time":1642578313,"label_colors":{"Children:":"#00d1c1","Female":"#ff5a5f","Male":"#7b0051","Total":"#007A87"},"metrics":[{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"Children:","optionName":"metric_5zz4ts5sh1a_d92dogwec19","sqlExpression":"SUM(coalesce(\"Counselling_L\",0))"}],"order_bars":false,"reduce_x_ticks":true,"remote_id":567,"row_limit":10000,"schema":"","show_bar_value":false,"show_controls":false,"show_legend":false,"slice_id":2125,"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"}
|