| Parameters |
{"adhoc_filters": [{"clause": "WHERE", "comparator": "age_category", "expressionType": "SIMPLE", "filterOptionName": "filter_bfwadv5nj6u_9dm61fty80k", "fromFormData": true, "operator": "==", "sqlExpression": null, "subject": "type"}], "bar_stacked": false, "bottom_margin": "auto", "color_scheme": "bnbColors", "columns": [], "contribution": false, "datasource": "73__table", "granularity_sqla": null, "groupby": ["Age in years"], "label_colors": {"2015": "#ff8083", "2015 Children:": "#ffb400", "2018": "#cc0086", "2018 Children:": "#b4a76c", "Any physical violence": "#ff3339", "Any sexual violence": "#7b0051", "Children:": "#00d1c1", "Ever": "#cc0086", "Female": "#ff5a5f", "Forced her with threats or in any other way to perform sexual acts she did not want to": "#007A87", "Kicked her, dragged her, or beat her up": "#ff1ab1", "Male": "#7b0051", "No disability or difficulty": "#ffb400", "Often": "#00a1b3", "Often or sometimes": "#00ffeb", "Percentage": "#8ce071", "Physical violence": "#ffd266", "Physically forced her to have sexual intercourse with him when she did not want to": "#00d1c1", "Physically forced her to perform any other sexual acts she did not want to": "#8ce071", "Punched her with his fist or with something that could hurt her": "#005c66", "Pushed her, shook her, or threw something at her": "#00b3a5", "Sexual violence": "#cbc29a", "Slapped her": "#55d12e", "Some difficulty": "#b4a76c", "Sometimes": "#bbedab", "Threatened her or attacked her with a knife, gun, or other weapon": "#b37e00", "Total": "#007A87", "Tried to choke her or burn her on purpose": "#988b4e", "Twisted her arm or pulled her hair": "#ff5a5f", "a lot of difficulty or cannot do": "#ff8083"}, "metrics": [{"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Human trafficking", "optionName": "metric_xtvlmawaga_bobz8ndexpo", "sqlExpression": "SUM(coalesce(\"Human trafficking\"::NUMERIC,0))"}, {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Sexual exploitation", "optionName": "metric_0fp29omzpa9g_hvsvwfuo3ic", "sqlExpression": "SUM(coalesce(\"Sexual exploitation\"::NUMERIC,0))"}, {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Child Rape", "optionName": "metric_u7bjwg8c81h_bz3tyhl02qn", "sqlExpression": "SUM(coalesce(\"Child Rape\"::NUMERIC,0))"}], "order_bars": false, "reduce_x_ticks": false, "row_limit": 10000, "show_bar_value": true, "show_controls": false, "show_legend": true, "slice_id": 776, "time_range": "Last week", "url_params": {}, "viz_type": "dist_bar", "x_axis_label": "Age category", "x_ticks_layout": "auto", "y_axis_format": ".1s", "y_axis_label": "", "remote_id": 776, "datasource_name": "domain_4_3_offence_data", "schema": null, "database_name": "UNICEF Cambodia", "import_time": 1642578313}
|
| Query Context |
{"datasource":{"id":73,"type":"table"},"force":false,"queries":[{"time_range":"Last week","granularity":null,"filters":[{"col":"type","op":"==","val":"age_category"}],"extras":{"having":"","where":""},"applied_time_extras":{},"columns":["Age in years"],"metrics":[{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"Human trafficking","optionName":"metric_xtvlmawaga_bobz8ndexpo","sqlExpression":"SUM(coalesce(\"Human trafficking\"::NUMERIC,0))"},{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"Sexual exploitation","optionName":"metric_0fp29omzpa9g_hvsvwfuo3ic","sqlExpression":"SUM(coalesce(\"Sexual exploitation\"::NUMERIC,0))"},{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"Child Rape","optionName":"metric_u7bjwg8c81h_bz3tyhl02qn","sqlExpression":"SUM(coalesce(\"Child Rape\"::NUMERIC,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":"age_category","expressionType":"SIMPLE","filterOptionName":"filter_bfwadv5nj6u_9dm61fty80k","fromFormData":true,"operator":"==","sqlExpression":null,"subject":"type"}],"bar_stacked":false,"bottom_margin":"auto","color_scheme":"bnbColors","columns":[],"contribution":false,"database_name":"UNICEF Cambodia","datasource":"73__table","datasource_name":"domain_4_3_offence_data","granularity_sqla":null,"groupby":["Age in years"],"import_time":1642578313,"label_colors":{"2015":"#ff8083","2018":"#cc0086","2015 Children:":"#ffb400","2018 Children:":"#b4a76c","Any physical violence":"#ff3339","Any sexual violence":"#7b0051","Children:":"#00d1c1","Ever":"#cc0086","Female":"#ff5a5f","Forced her with threats or in any other way to perform sexual acts she did not want to":"#007A87","Kicked her, dragged her, or beat her up":"#ff1ab1","Male":"#7b0051","No disability or difficulty":"#ffb400","Often":"#00a1b3","Often or sometimes":"#00ffeb","Percentage":"#8ce071","Physical violence":"#ffd266","Physically forced her to have sexual intercourse with him when she did not want to":"#00d1c1","Physically forced her to perform any other sexual acts she did not want to":"#8ce071","Punched her with his fist or with something that could hurt her":"#005c66","Pushed her, shook her, or threw something at her":"#00b3a5","Sexual violence":"#cbc29a","Slapped her":"#55d12e","Some difficulty":"#b4a76c","Sometimes":"#bbedab","Threatened her or attacked her with a knife, gun, or other weapon":"#b37e00","Total":"#007A87","Tried to choke her or burn her on purpose":"#988b4e","Twisted her arm or pulled her hair":"#ff5a5f","a lot of difficulty or cannot do":"#ff8083"},"metrics":[{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"Human trafficking","optionName":"metric_xtvlmawaga_bobz8ndexpo","sqlExpression":"SUM(coalesce(\"Human trafficking\"::NUMERIC,0))"},{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"Sexual exploitation","optionName":"metric_0fp29omzpa9g_hvsvwfuo3ic","sqlExpression":"SUM(coalesce(\"Sexual exploitation\"::NUMERIC,0))"},{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"Child Rape","optionName":"metric_u7bjwg8c81h_bz3tyhl02qn","sqlExpression":"SUM(coalesce(\"Child Rape\"::NUMERIC,0))"}],"order_bars":false,"reduce_x_ticks":false,"remote_id":776,"row_limit":10000,"schema":null,"show_bar_value":true,"show_controls":false,"show_legend":true,"slice_id":2334,"time_range":"Last week","url_params":{},"viz_type":"dist_bar","x_axis_label":"Age category","x_ticks_layout":"auto","y_axis_format":".1s","y_axis_label":"","force":false,"result_format":"json","result_type":"full"},"result_format":"json","result_type":"full"}'" dtfy=HT6FcWOK x="'
|
