Parameters |
{
"adhoc_filters": [
{
"clause": "WHERE",
"comparator": "",
"expressionType": "SIMPLE",
"filterOptionName": "filter_i80a62qw2dg_onmpsnhtqa",
"fromFormData": true,
"operator": "IS NOT NULL",
"sqlExpression": null,
"subject": "project_theme_id"
},
{
"clause": "WHERE",
"comparator": "2014-2020",
"expressionType": "SIMPLE",
"filterOptionName": "filter_348yjwi9tal_9e5b7rk8f3o",
"fromFormData": true,
"operator": "==",
"sqlExpression": null,
"subject": "programme_period_title"
},
{
"clause": "WHERE",
"comparator": "",
"expressionType": "SIMPLE",
"filterOptionName": "filter_gxhjfvaw6hd_1zdedajeuru",
"fromFormData": true,
"operator": "IS NOT NULL",
"sqlExpression": null,
"subject": "project_start_date"
}
],
"annotation_layers": [],
"bottom_margin": "auto",
"color_scheme": "keep",
"comparison_type": "values",
"contribution": false,
"datasource": "14__table",
"granularity_sqla": "project_start_date",
"groupby": [
"project_theme_title"
],
"label_colors": {},
"left_margin": "auto",
"limit": 5,
"line_interpolation": "monotone",
"metrics": [
"sum_partnership_budgets"
],
"order_desc": true,
"resample_method": null,
"resample_rule": null,
"rich_tooltip": true,
"rolling_type": "None",
"row_limit": null,
"send_time_range": false,
"show_brush": "no",
"show_legend": true,
"show_markers": true,
"slice_id": 333,
"time_grain_sqla": "P1Y",
"time_range": "No filter",
"timeseries_limit_metric": [],
"url_params": {},
"viz_type": "line",
"x_axis_format": "smart_date",
"x_axis_label": "Projects start year",
"x_axis_showminmax": true,
"x_ticks_layout": "auto",
"y_axis_bounds": [
null,
null
],
"y_axis_format": ",.2f",
"y_axis_label": "Budget (\u20ac)",
"y_axis_showminmax": true,
"y_log_scale": false
}
|