Show Chart

Last Saved By Ona
Owners [Ona ]
Tags []
Table 4_1_indicator_summary
Created By Ona
Changed By Ona
Uuid 62293c92-3b97-2bf9-ad56-6ac2b22e6f53
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", "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}
Query Context None
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[4_1_indicator_summary](id:97)
Schema Perm None
Last Saved At 2022-01-19 07:45:53.242991
Certified By None
Certification Details None
Is Managed Externally False
External Url None
Dashboards [Dashboard<38>, Dashboard<41>]
Report Schedules []