Show Chart

Owners [Ona ]
Created By Ona
Changed By Ona
Created On 2021-11-22 11:49:59.998003
Changed On 2021-12-14 11:21:32.178092
Name Donor funding by sector
Datasource Id 96
Datasource Type table
Datasource Name indicator2_6_disagg_data
Visualization Type dist_bar
Parameters { "adhoc_filters": [ { "clause": "WHERE", "comparator": null, "expressionType": "SQL", "filterOptionName": "filter_e7lybhc7eq9_707xhi1cwwp", "fromFormData": true, "operator": null, "sqlExpression": "\"Sector\" IS NOT NULL AND \"Sector\" <> 'Total donors budget for development'", "subject": null } ], "bar_stacked": false, "bottom_margin": "5", "color_scheme": "bnbColors", "columns": [], "contribution": false, "datasource": "96__table", "granularity_sqla": null, "groupby": [ "Sector" ], "label_colors": { "Agriculture": "#8ce071", "Budget": "#007A87", "Business and financial services": "#cbc29a", "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", "Governance and gender": "#cc0086", "Health and HIV and AIDS": "#ffb400", "Others (Tourism, industralisation, ICT, trade)": "#ff1ab1", "Rural development": "#00ffeb", "Total Budget": "#ff5a5f", "Total CP Budget": "#7b0051", "Transportation": "#00d1c1", "UNDP": "#988b4e", "UNICEF": "#00b3a5", "USAID": "#55d12e", "Urban planning": "#005c66", "Water and sanitation": "#00a1b3" }, "metrics": [ { "aggregate": "SUM", "column": { "column_name": "Total Budget", "database_expression": "", "description": "", "expression": "", "filterable": true, "groupby": true, "id": 42958, "is_dttm": false, "optionName": "_col_Total Budget", "python_date_format": "", "type": "DOUBLE PRECISION", "verbose_name": "" }, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "Budget", "optionName": "metric_j6cqb8vjsu9_rfflgxjyy9", "sqlExpression": null } ], "order_bars": false, "reduce_x_ticks": true, "row_limit": 10000, "show_bar_value": false, "show_controls": false, "show_legend": false, "slice_id": 673, "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": "" }
Description None
Cache Timeout None
Perm [UNICEF Cambodia].[indicator2_6_disagg_data](id:96)
Schema Perm None
Dashboards [Cambodia Child Protection Profile 2018]
Email Schedules []