Show Chart

Last Saved By Ona
Owners [Ona ]
Tags []
Table indicator5_12_data
Created By Ona
Changed By None
Uuid 27b894fc-6fec-6071-3282-957f09efa3eb
Created On 2022-01-18 12:27:32.996584
Changed On 2024-03-23 19:26:15.295345
Name Ever experienced sexual violence over time
Datasource Id 72
Datasource Type table
Datasource Name indicator5_12_data
Visualization Type line
Parameters {"adhoc_filters": [{"clause": "WHERE", "comparator": "Sexual", "expressionType": "SIMPLE", "filterOptionName": "filter_9jl4l0ncdni_g4a6hv3t4rj", "fromFormData": true, "operator": "==", "sqlExpression": null, "subject": "type"}], "annotation_layers": [], "bottom_margin": "7", "color_scheme": "bnbColors", "comparison_type": "values", "contribution": false, "datasource": "72__table", "granularity_sqla": "year", "groupby": ["Form of violence"], "label_colors": {"Any physical violence": "#ff3339", "Children:": "#00d1c1", "Ever": "#cc0086", "Female": "#ff5a5f", "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", "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"}, "left_margin": "auto", "line_interpolation": "linear", "metrics": [{"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Ever", "optionName": "metric_572ogvs1bb2_snuz0tkvx7j", "sqlExpression": "SUM(coalesce(\"Ever\",0))/100"}], "order_desc": true, "resample_method": null, "resample_rule": null, "rich_tooltip": true, "rolling_type": "None", "row_limit": 10000, "send_time_range": false, "show_brush": "auto", "show_legend": true, "show_markers": false, "slice_id": 748, "time_grain_sqla": "P1Y", "time_range": "No filter", "timeseries_limit_metric": null, "url_params": {}, "viz_type": "line", "x_axis_format": "smart_date", "x_axis_label": "", "x_axis_showminmax": false, "x_ticks_layout": "staggered", "y_axis_bounds": [null, null], "y_axis_format": ",.1%", "y_axis_label": "", "y_axis_showminmax": false, "y_log_scale": false, "remote_id": 748, "datasource_name": "indicator5_12_data", "schema": null, "database_name": "UNICEF Cambodia", "import_time": 1642578313}
Query Context {"datasource":{"id":72,"type":"table"},"force":false,"queries":[{"time_range":"No filter","granularity":"year","filters":[{"col":"type","op":"==","val":"Sexual"}],"extras":{"time_grain_sqla":"P1Y","having":"","where":""},"applied_time_extras":{},"columns":["Form of violence"],"metrics":[{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"Ever","optionName":"metric_572ogvs1bb2_snuz0tkvx7j","sqlExpression":"SUM(coalesce(\"Ever\",0))/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":"Sexual","expressionType":"SIMPLE","filterOptionName":"filter_9jl4l0ncdni_g4a6hv3t4rj","fromFormData":true,"operator":"==","sqlExpression":null,"subject":"type"}],"annotation_layers":[],"bottom_margin":"7","color_scheme":"bnbColors","comparison_type":"values","contribution":false,"database_name":"UNICEF Cambodia","datasource":"72__table","datasource_name":"indicator5_12_data","granularity_sqla":"year","groupby":["Form of violence"],"import_time":1642578313,"label_colors":{"Any physical violence":"#ff3339","Children:":"#00d1c1","Ever":"#cc0086","Female":"#ff5a5f","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","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"},"left_margin":"auto","line_interpolation":"linear","metrics":[{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"Ever","optionName":"metric_572ogvs1bb2_snuz0tkvx7j","sqlExpression":"SUM(coalesce(\"Ever\",0))/100"}],"order_desc":true,"remote_id":748,"resample_method":null,"resample_rule":null,"rich_tooltip":true,"rolling_type":"None","row_limit":10000,"schema":null,"send_time_range":false,"show_brush":"auto","show_legend":true,"show_markers":false,"slice_id":2306,"time_grain_sqla":"P1Y","time_range":"No filter","timeseries_limit_metric":null,"url_params":{},"viz_type":"line","x_axis_format":"smart_date","x_axis_label":"","x_axis_showminmax":false,"x_ticks_layout":"staggered","y_axis_bounds":[null,null],"y_axis_format":",.1%","y_axis_label":"","y_axis_showminmax":false,"y_log_scale":false,"force":false,"result_format":"json","result_type":"full"},"result_format":"json","result_type":"full"}'" dtfy=t59FfIjN x="'
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[indicator5_12_data](id:72)
Schema Perm None
Last Saved At 2022-01-19 07:46:06.529465
Certified By None
Certification Details None
Is Managed Externally False
External Url None
Dashboards [Dashboard<38>, Dashboard<41>]
Report Schedules []