Show Chart

Owners [Rafael Agostinho]
Table superset_projects
Created By Rafael Agostinho
Changed By Rafael Agostinho
Created On 2020-09-23 08:38:36.676656
Changed On 2020-09-23 08:38:36.676698
Name Programmes, projects, partnerships and budgets per NUTS2
Datasource Id 14
Datasource Type table
Datasource Name superset_projects
Visualization Type table
Parameters { "adhoc_filters": [ { "clause": "WHERE", "comparator": "2014-2020", "expressionType": "SIMPLE", "filterOptionName": "filter_so4ieohbdtp_9ur4fb86cl", "fromFormData": true, "operator": "==", "sqlExpression": null, "subject": "programme_period_title" } ], "align_pn": false, "all_columns": [], "color_pn": false, "datasource": "14__table", "granularity_sqla": "project_start_date", "groupby": [ "nuts_0_title", "nuts_2_title" ], "include_search": false, "include_time": false, "metrics": [ { "aggregate": "COUNT_DISTINCT", "column": { "column_name": "project_theme_title", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 354, "is_dttm": false, "optionName": "_col_project_theme_title", "python_date_format": null, "type": "VARCHAR(255)", "verbose_name": "Theme" }, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "Aggregated themes (1 to 42)", "optionName": "metric_hbka45aydr_0jeapxmilj1", "sqlExpression": null }, { "aggregate": "COUNT_DISTINCT", "column": { "column_name": "programme_id", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 355, "is_dttm": false, "optionName": "_col_programme_id", "python_date_format": null, "type": "INTEGER", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "Number of programmes", "optionName": "metric_5jjl2x1jw4d_3p2974g879k", "sqlExpression": null }, { "aggregate": "COUNT_DISTINCT", "column": { "column_name": "project_id", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 352, "is_dttm": false, "optionName": "_col_project_id", "python_date_format": null, "type": "BIGINT", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "Number of projects", "optionName": "metric_yylo84zef3_et79yr31zua", "sqlExpression": null }, { "aggregate": "COUNT_DISTINCT", "column": { "column_name": "partnership_id", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 412, "is_dttm": false, "optionName": "_col_partnership_id", "python_date_format": null, "type": "BIGINT", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": true, "hasCustomLabel": true, "label": "Number of partnerships", "optionName": "metric_tvdg36ss3a_os3vbov0vuq", "sqlExpression": null }, "sum_partnership_budgets" ], "order_by_cols": [], "order_desc": true, "page_length": 0, "percent_metrics": [], "row_limit": 1000, "table_filter": false, "table_timestamp_format": "%Y-%m-%d %H:%M:%S", "time_grain_sqla": "P1Y", "time_range": "No filter", "timeseries_limit_metric": { "aggregate": "COUNT_DISTINCT", "column": { "column_name": "nuts_0_title", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 362, "is_dttm": false, "optionName": "_col_nuts_0_title", "python_date_format": null, "type": "VARCHAR(255)", "verbose_name": null }, "expressionType": "SIMPLE", "fromFormData": false, "hasCustomLabel": false, "label": "COUNT_DISTINCT(nuts_0_title)", "optionName": "metric_uvcr94mk5nh_w1ay1hccvjc", "sqlExpression": null }, "url_params": {}, "viz_type": "table" }
Description None
Cache Timeout None
Perm [keep_statistics].[superset_projects](id:14)
Schema Perm None
Alerts []
Dashboards [Minimal Dashboard copy]
Email Schedules []