UNICEF Cambodia Discover

Edit Chart

Name
Description	The content here can be displayed as widget headers in the dashboard view. Supports markdown
Visualization Type
Owners
Dashboards
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} These parameters are generated dynamically when clicking the save or overwrite button in the explore view. This JSON object is exposed here for reference and for power users who may want to alter specific parameters.
Cache Timeout	Duration (in seconds) of the caching timeout for this chart. Note this defaults to the datasource/table timeout if undefined.