Show Chart

Last Saved By Ona
Owners [Ona ]
Tags []
Table 4_1_indicator_summary
Created By Ona
Changed By Ona
Uuid 3bf75083-5a0d-31b6-881c-633a67b95a4c
Created On 2021-11-22 11:49:49.004885
Changed On 2021-12-31 13:30:19.828683
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": {"% 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_5zz4ts5sh1a_d92dogwec19", "sqlExpression": "SUM(coalesce(\"MoSVY_CWD_B\",0))"}], "order_bars": false, "reduce_x_ticks": true, "row_limit": 10000, "show_bar_value": false, "show_controls": false, "show_legend": false, "slice_id": 530, "time_range": "Last week", "url_params": {}, "viz_type": "dist_bar", "x_axis_label": "", "x_ticks_layout": "auto", "y_axis_format": ",", "y_axis_label": ""}
Query Context None
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[4_1_indicator_summary](id:97)
Schema Perm None
Last Saved At 2021-12-31 13:30:19.828683
Certified By None
Certification Details None
Is Managed Externally False
External Url None
Dashboards [Dashboard<31>]
Report Schedules []