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": [ "Health", "Education", "Social work", "Emergency and medical services", "Physical rehabiliation", "Medical rehabilitation", "Reintegration services", "Inspection services", "Counseling services", "Trafficking survivor (Repatriation)", "Trafficking survivor (Rehabilitation)", "Trafficking survivor (Reintegration)" ], "expressionType": "SIMPLE", "filterOptionName": "filter_j9oemmayyg8_5qktv34wjxc", "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": { "0-1 Years": "#007A87", "2-4 Years": "#7b0051", "2015": "#b37e00", "2015 Children:": "#00b3a5", "2018": "#988b4e", "2018 Children:": "#55d12e", "Agriculture": "#8ce071", "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", "Female": "#ff8083", "Forster and/or Orphans": "#ff5a5f", "Foster": "#7b0051", "Governance and gender": "#cc0086", "Health and HIV and AIDS": "#ffb400", "Human trafficking": "#ff1ab1", "Male": "#b4a76c", "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", "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" }, "metrics": [ { "aggregate": null, "column": null, "expressionType": "SQL", "fromFormData": true, "hasCustomLabel": true, "label": "Children:", "optionName": "metric_5zz4ts5sh1a_d92dogwec19", "sqlExpression": "SUM(coalesce(\"PwDF_J\",0))" } ], "order_bars": false, "reduce_x_ticks": true, "row_limit": 10000, "show_bar_value": false, "show_controls": false, "show_legend": false, "slice_id": 561, "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": "" } 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.