Show Chart

Last Saved By Ona
Owners [Ona ]
Tags []
Table 4_7_trend_rci_summary
Created By Ona
Changed By Ona
Uuid 516fbe5c-4ac5-6149-dc4a-67ade9f999a0
Created On 2022-01-18 12:27:22.833492
Changed On 2022-01-19 07:45:58.281209
Name Number of children by age group per year
Datasource Id 86
Datasource Type table
Datasource Name 4_7_trend_rci_summary
Visualization Type dist_bar
Parameters {"adhoc_filters": [{"clause": "WHERE", "comparator": ["0-3 years", "4-9 years", "10-14 years", "15-17 years"], "expressionType": "SIMPLE", "filterOptionName": "filter_2trg2jrq4u1_adc840zcee", "fromFormData": true, "operator": "in", "sqlExpression": null, "subject": "Item"}], "bar_stacked": false, "bottom_margin": "auto", "color_scheme": "bnbColors", "columns": [], "contribution": false, "datasource": "86__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": "2015 Children:", "optionName": "metric_2q0u1rsy6lo_dvnglt1z4j8", "sqlExpression": "SUM(coalesce(\"RCI_2015\",0))"}, {"aggregate": "SUM", "column": {"column_name": "RCI_2018", "database_expression": "", "description": "", "expression": "", "filterable": true, "groupby": true, "id": 42307, "is_dttm": false, "optionName": "_col_RCI_2018", "python_date_format": "", "type": "BIGINT", "verbose_name": ""}, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "2018 Children:", "optionName": "metric_s2x6es0mxbd_807vospm20v", "sqlExpression": null}], "order_bars": false, "reduce_x_ticks": false, "row_limit": 10000, "show_bar_value": false, "show_controls": false, "show_legend": true, "slice_id": 606, "time_range": "Last week", "url_params": {}, "viz_type": "dist_bar", "x_axis_label": "", "x_ticks_layout": "staggered", "y_axis_format": ",", "y_axis_label": "", "remote_id": 606, "datasource_name": "4_7_trend_rci_summary", "schema": "", "database_name": "UNICEF Cambodia", "import_time": 1642578313}
Query Context None
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[4_7_trend_rci_summary](id:86)
Schema Perm None
Last Saved At 2022-01-19 07:45:58.281209
Certified By None
Certification Details None
Is Managed Externally False
External Url None
Dashboards [Dashboard<38>, Dashboard<41>]
Report Schedules []