Show Chart

Last Saved By Ona
Owners [Ona ]
Tags []
Table 4_1_indicator_summary
Created By Ona
Changed By None
Uuid 0b9b4b49-4140-637c-b57e-98c1ee73220c
Created On 2022-01-18 12:27:20.042626
Changed On 2024-03-28 13:35:42.888482
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", "url_params": {}, "viz_type": "dist_bar", "x_axis_label": "", "x_ticks_layout": "auto", "y_axis_format": ",", "y_axis_label": "", "remote_id": 567, "datasource_name": "4_1_indicator_summary", "schema": "", "database_name": "UNICEF Cambodia", "import_time": 1642578313}
Query Context {"datasource":{"id":97,"type":"table"},"force":false,"queries":[{"time_range":"Last week","granularity":null,"filters":[{"col":"item","op":"in","val":["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"]}],"extras":{"having":"","where":""},"applied_time_extras":{},"columns":["item"],"metrics":[{"aggregate":null,"column":null,"expressionType":"SQL","fromFormData":true,"hasCustomLabel":true,"label":"Children:","optionName":"metric_5zz4ts5sh1a_d92dogwec19","sqlExpression":"SUM(coalesce(\"Counselling_L\",0))"}],"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":["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,"database_name":"UNICEF Cambodia","datasource":"97__table","datasource_name":"4_1_indicator_summary","granularity_sqla":null,"groupby":["item"],"import_time":1642578313,"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,"remote_id":567,"row_limit":10000,"schema":"","show_bar_value":false,"show_controls":false,"show_legend":false,"slice_id":2125,"time_range":"Last week","url_params":{},"viz_type":"dist_bar","x_axis_label":"","x_ticks_layout":"auto","y_axis_format":",","y_axis_label":"","force":false,"result_format":"json","result_type":"full"},"result_format":"json","result_type":"full"}
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:56.032323
Certified By None
Certification Details None
Is Managed Externally False
External Url None
Dashboards [Dashboard<38>, Dashboard<41>]
Report Schedules []