| Parameters |
{"adhoc_filters": [{"clause": "WHERE", "comparator": ["0-2 years", "3-9 years", "10-14 years", "15-17 years", "18 years or above"], "expressionType": "SIMPLE", "filterOptionName": "filter_q242kit2qqi_gabkcddh36u", "fromFormData": true, "operator": "in", "sqlExpression": null, "subject": "item"}], "bar_stacked": false, "bottom_margin": "auto", "color_scheme": "bnbColors", "columns": [], "contribution": false, "datasource": "97__table", "granularity_sqla": null, "groupby": ["item"], "label_colors": {"% Female": "#7b0051", "% Male": "#007A87", "% trained Female": "#988b4e", "% trained Male": "#ff5a5f", "0-1 Years": "#b4a76c", "14-15 years": "#ff8083", "16-17 years": "#b4a76c", "2-4 Years": "#ffb400", "2015": "#005c66", "2015 Children:": "#ff3339", "2018": "#00b3a5", "2018 Children:": "#ff1ab1", "< 14 years": "#cc0086", "At least one mou": "#005c66", "Child Offender": "#00a1b3", "Child Rape": "#bbedab", "Child Victim": "#00ffeb", "Children": "#ff1ab1", "Children:": "#cc0086", "Fathers": "#cbc29a", "Female": "#7b0051", "Forster and/or Orphans": "#ff5a5f", "Foster": "#55d12e", "Have authorization": "#00b3a5", "Human trafficking": "#ffd266", "Kinship": "#b37e00", "Male": "#ff5a5f", "Meeting Standards": "#55d12e", "Mothers": "#ff3339", "Never sought help but told someone": "#00d1c1", "Never sought help, never told anyone": "#8ce071", "Percentage": "#007A87", "Registered": "#00a1b3", "Registred": "#ffd266", "Rural": "#8ce071", "Sexual exploitation": "#cbc29a", "Single Orphans": "#7b0051", "Sought help": "#ffb400", "Total": "#ff8083", "Total Number of Teachers": "#b37e00", "Urban": "#00d1c1", "With Birth Certificate": "#00ffeb", "Without Birth Certificate": "#bbedab", "children:": "#988b4e"}, "metrics": [{"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Children:", "optionName": "metric_gp87y1y3ydi_ajym0qwqftd", "sqlExpression": "SUM(coalesce(\"MoSVY_CWD_B\",0))"}], "order_bars": false, "reduce_x_ticks": false, "row_limit": 10000, "show_bar_value": false, "show_controls": false, "show_legend": false, "slice_id": 529, "time_range": "Last week", "url_params": {}, "viz_type": "dist_bar", "x_axis_label": "", "x_ticks_layout": "flat", "y_axis_format": ",", "y_axis_label": "", "remote_id": 529, "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":["0-2 years","3-9 years","10-14 years","15-17 years","18 years or above"]}],"extras":{"having":"","where":""},"applied_time_extras":{},"columns":["item"],"metrics":[{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"Children:","optionName":"metric_gp87y1y3ydi_ajym0qwqftd","sqlExpression":"SUM(coalesce(\"MoSVY_CWD_B\",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":["0-2 years","3-9 years","10-14 years","15-17 years","18 years or above"],"expressionType":"SIMPLE","filterOptionName":"filter_q242kit2qqi_gabkcddh36u","fromFormData":true,"operator":"in","sqlExpression":null,"subject":"item"}],"bar_stacked":false,"bottom_margin":"auto","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":{"2015":"#005c66","2018":"#00b3a5","% Female":"#7b0051","% Male":"#007A87","% trained Female":"#988b4e","% trained Male":"#ff5a5f","0-1 Years":"#b4a76c","14-15 years":"#ff8083","16-17 years":"#b4a76c","2-4 Years":"#ffb400","2015 Children:":"#ff3339","2018 Children:":"#ff1ab1","< 14 years":"#cc0086","At least one mou":"#005c66","Child Offender":"#00a1b3","Child Rape":"#bbedab","Child Victim":"#00ffeb","Children":"#ff1ab1","Children:":"#cc0086","Fathers":"#cbc29a","Female":"#7b0051","Forster and/or Orphans":"#ff5a5f","Foster":"#55d12e","Have authorization":"#00b3a5","Human trafficking":"#ffd266","Kinship":"#b37e00","Male":"#ff5a5f","Meeting Standards":"#55d12e","Mothers":"#ff3339","Never sought help but told someone":"#00d1c1","Never sought help, never told anyone":"#8ce071","Percentage":"#007A87","Registered":"#00a1b3","Registred":"#ffd266","Rural":"#8ce071","Sexual exploitation":"#cbc29a","Single Orphans":"#7b0051","Sought help":"#ffb400","Total":"#ff8083","Total Number of Teachers":"#b37e00","Urban":"#00d1c1","With Birth Certificate":"#00ffeb","Without Birth Certificate":"#bbedab","children:":"#988b4e"},"metrics":[{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"Children:","optionName":"metric_gp87y1y3ydi_ajym0qwqftd","sqlExpression":"SUM(coalesce(\"MoSVY_CWD_B\",0))"}],"order_bars":false,"reduce_x_ticks":false,"remote_id":529,"row_limit":10000,"schema":"","show_bar_value":false,"show_controls":false,"show_legend":false,"slice_id":2087,"time_range":"Last week","url_params":{},"viz_type":"dist_bar","x_axis_label":"","x_ticks_layout":"flat","y_axis_format":",","y_axis_label":"","force":false,"result_format":"json","result_type":"full"},"result_format":"json","result_type":"full"}
|
