Show Chart

Owners [Ona ]
Created By Ona
Changed By Ona
Created On 2022-01-18 12:27:16.891348
Changed On 2022-01-19 07:45:53.242991
Name Number of children by reason for opening the case
Datasource Id 97
Datasource Type table
Datasource Name 4_1_indicator_summary
Visualization Type dist_bar
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": "6", "color_scheme": "bnbColors", "columns": [], "contribution": false, "datasource": "97__table", "granularity_sqla": null, "groupby": ["item"], "label_colors": {"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": "Children:", "optionName": "metric_5zz4ts5sh1a_d92dogwec19", "sqlExpression": "SUM(coalesce(\"MoSVY_CWD_A\",0))"}], "order_bars": false, "reduce_x_ticks": true, "row_limit": 10000, "show_bar_value": false, "show_controls": false, "show_legend": false, "slice_id": 523, "time_range": "Last week", "time_range_endpoints": ["unknown", "inclusive"], "url_params": {}, "viz_type": "dist_bar", "x_axis_label": "", "x_ticks_layout": "auto", "y_axis_format": ",", "y_axis_label": "", "remote_id": 523, "datasource_name": "4_1_indicator_summary", "schema": "", "database_name": "UNICEF Cambodia", "import_time": 1642578313}
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[4_1_indicator_summary](id:97)
Schema Perm None
Dashboards [Cambodia Child Protection Profile 2018 - TEST, Cambodia Child Protection Profile 2018 - TEST2]
Email Schedules []