| 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", "url_params": {}, "viz_type": "dist_bar", "x_axis_label": "", "x_ticks_layout": "auto", "y_axis_format": ",", "y_axis_label": "", "remote_id": 673, "datasource_name": "indicator2_6_disagg_data", "schema": null, "database_name": "UNICEF Cambodia", "import_time": 1642578313}
|
