Show Chart

Owners [Rafael Agostinho]
Table superset_projects
Created By Rafael Agostinho
Changed By Rafael Agostinho
Created On 2020-09-23 07:16:49.409595
Changed On 2020-09-23 07:16:49.409612
Name Budget (2014-2020 only) per five main themes per project start year
Datasource Id 14
Datasource Type table
Datasource Name superset_projects
Visualization Type line
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 }
Description Mouseover for figures. Click on the question mark next to the header to find out more and understand some simple cautions for dealing with this data. Use the filters on the left to get the figures adjusted to your geography, thematic interest, programme type, etc. After adjusting the chart to your interests, export it to Excel to get hold of the figures, or save the image for your use.
Cache Timeout None
Perm [keep_statistics].[superset_projects](id:14)
Schema Perm None
Alerts []
Dashboards []
Email Schedules []