Show Chart

Owners [Ona ]
Created By Ona
Changed By Ona
Created On 2021-11-22 11:49:51.837892
Changed On 2021-12-15 01:57:28.299926
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": "5", "color_scheme": "bnbColors", "columns": [], "contribution": false, "datasource": "97__table", "granularity_sqla": null, "groupby": [ "item" ], "label_colors": { "Children:": "#00d1c1", "Female": "#ff5a5f", "Male": "#7b0051", "Total": "#007A87" }, "metrics": [ { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Children:", "optionName": "metric_5zz4ts5sh1a_d92dogwec19", "sqlExpression": "SUM(coalesce(\"Counselling_L\",0))" } ], "order_bars": false, "reduce_x_ticks": true, "row_limit": 10000, "show_bar_value": false, "show_controls": false, "show_legend": false, "slice_id": 567, "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": "" }
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[4_1_indicator_summary](id:97)
Schema Perm None
Dashboards [Cambodia Child Protection Profile 2018]
Email Schedules []