Show Chart

Last Saved By Rafael Agostinho
Owners [Rafael Agostinho]
Table superset_projects
Created By Rafael Agostinho
Changed By Rafael Agostinho
Uuid 4c388317-4729-285f-3086-026daa367f65
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 }
Query Context None
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
Last Saved At 2020-09-23 07:16:49.409612
Certified By None
Certification Details None
Alerts []
Email Schedules []
Dashboards []
Report Schedules []