Show Chart

Last Saved By Sofokus Admin
Owners [Sofokus Admin]
Table superset_projects
Created By Sofokus Admin
Changed By Sofokus Admin
Uuid 6f9acda1-d5de-5b94-a9fa-1d93b8c10fca
Created On 2019-12-14 17:59:38.335846
Changed On 2020-04-09 07:21:16.569927
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-04-09 07:21:16.569927
Certified By None
Certification Details None
Alerts []
Email Schedules []
Dashboards [Dashboard<1>]
Report Schedules []