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": ""
}
|