Parameters |
{
"adhoc_filters": [
{
"clause": "WHERE",
"comparator": null,
"expressionType": "SQL",
"filterOptionName": "filter_57fh6fcs5hk_ng8zg9xh38j",
"fromFormData": true,
"operator": null,
"sqlExpression": "activity <> 'Total budget for child protection' AND activity <> 'Total budget for development' AND activity <> '% of NGOs budget for child protection'",
"subject": null
}
],
"bar_stacked": false,
"bottom_margin": "5",
"color_scheme": "bnbColors",
"columns": [],
"contribution": false,
"datasource": "99__table",
"granularity_sqla": null,
"groupby": [
"activity"
],
"label_colors": {
"2015": "#7b0051",
"2018": "#007A87",
"RCIs": "#ff5a5f",
"Total Budget": "#00d1c1"
},
"metrics": [
{
"aggregate": null,
"column": null,
"expressionType": "SQL",
"fromFormData": true,
"hasCustomLabel": true,
"label": "Total Budget",
"optionName": "metric_17jtvub6zmv_z6nmr9gl8i",
"sqlExpression": "ROUND(SUM(\"Total \" ))"
}
],
"order_bars": false,
"reduce_x_ticks": false,
"row_limit": 10000,
"show_bar_value": false,
"show_controls": false,
"show_legend": false,
"slice_id": 668,
"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": ""
}
|