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": "Province", "expressionType": "SIMPLE", "filterOptionName": "filter_eaaaqun7ve9_4klrpkbvlwl", "fromFormData": true, "operator": "==", "sqlExpression": null, "subject": "category"}, {"clause": "WHERE", "comparator": "2014", "expressionType": "SIMPLE", "filterOptionName": "filter_awkpb080io_82ssa9sjrc", "fromFormData": true, "operator": "==", "sqlExpression": null, "subject": "year"}], "bar_stacked": false, "bottom_margin": "auto", "color_scheme": "bnbColors", "columns": [], "contribution": false, "datasource": "65__table", "granularity_sqla": "year", "groupby": ["category_value"], "label_colors": {"0-1 Years": "#007A87", "2-4 Years": "#7b0051", "2015": "#b37e00", "2015 Children:": "#00b3a5", "2016": "#bbedab", "2017": "#ffd266", "2018": "#988b4e", "2018 Children:": "#55d12e", "Agriculture": "#8ce071", "Both alive": "#cbc29a", "Budget": "#007A87", "Business and financial services": "#cbc29a", "Child Rape": "#ff3339", "Children": "#ffd266", "Children:": "#00d1c1", "Climate change and environment": "#bbedab", "Community and social welfare, including child protection": "#ff3339", "Culture, arts and sports": "#ffd266", "EU/EC": "#b37e00", "Education": "#b4a76c", "Energy power and electricity": "#ff8083", "Father alive": "#ff3339", "Female": "#ff8083", "Forster and/or Orphans": "#ff5a5f", "Foster": "#7b0051", "Governance and gender": "#cc0086", "Health and HIV and AIDS": "#ffb400", "Human trafficking": "#ff1ab1", "Level 1": "#00a1b3", "Level 2": "#00ffeb", "Male": "#b4a76c", "Mother alive": "#ff1ab1", "No disability or difficulty": "#8ce071", "Not biological parent": "#00b3a5", "Not living with biological parent": "#005c66", "Others (Tourism, industralisation, ICT, trade)": "#ff1ab1", "Percentage": "#00d1c1", "RCIs": "#ff5a5f", "Registered": "#bbedab", "Registred": "#cc0086", "Rural": "#ffb400", "Rural development": "#00ffeb", "Sexual exploitation": "#005c66", "Single Orphans": "#007A87", "Some difficulty": "#ffb400", "Total": "#cbc29a", "Total Budget": "#7b0051", "Total CP Budget": "#ff5a5f", "Transportation": "#00d1c1", "UNDP": "#988b4e", "UNICEF": "#00b3a5", "USAID": "#55d12e", "Urban": "#8ce071", "Urban planning": "#005c66", "Water and sanitation": "#00a1b3", "With Birth Certificate": "#00a1b3", "Without Birth Certificate": "#00ffeb", "a lot of difficulty or cannot do": "#b4a76c", "level1": "#ff8083", "level2": "#cc0086"}, "metrics": [{"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Not living with biological parent", "optionName": "metric_g5rhz44bqja_tpmclkbz08f", "sqlExpression": "SUM(children_not_living_with_a_biological_parent)/100"}, {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Both alive", "optionName": "metric_4wmj9asc3e4_mxg90xn725q", "sqlExpression": "SUM(children_living_with_neither_parent_both_alive)/100"}, {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Father alive", "optionName": "metric_xptr5t9qxg_yueevmb8w3h", "sqlExpression": "SUM(children_living_with_neither_parent_father_alive)/100"}, {"aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Mother alive", "optionName": "metric_exwijtivln_pdnlr8jo3po", "sqlExpression": "SUM(children_living_with_neither_parent_mother_alive)/100"}], "order_bars": false, "reduce_x_ticks": true, "row_limit": 10000, "show_bar_value": false, "show_controls": false, "show_legend": true, "slice_id": 705, "time_range": "No filter", "time_range_endpoints": ["unknown", "inclusive"], "url_params": {}, "viz_type": "dist_bar", "x_axis_label": "", "x_ticks_layout": "auto", "y_axis_format": ",.1%", "y_axis_label": "", "remote_id": 705, "datasource_name": "indicator5_6_cdhs_data_updated", "schema": null, "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.