Show Chart

Owners [Rafael Agostinho]
Table superset_partnerships
Created By Rafael Agostinho
Changed By Rafael Agostinho
Created On 2020-10-28 13:29:44.159623
Changed On 2020-10-28 13:35:57.970529
Name Aggregated budgets per country, region and programme type (2014-2020)
Datasource Id 13
Datasource Type table
Datasource Name superset_partnerships
Visualization Type table
Parameters { "adhoc_filters": [ { "clause": "WHERE", "comparator": "2014-2020", "expressionType": "SIMPLE", "filterOptionName": "filter_yoeuxd6yz28_njvys6eyuon", "isExtra": false, "isNew": false, "operator": "==", "sqlExpression": null, "subject": "programme_period_title" } ], "all_columns": [ "nuts_0_title", "nuts_1_title", "nuts_2_title", "programme_period_title", "programme_type_title", "partnership_total_budget", "partnership_id" ], "color_pn": true, "datasource": "13__table", "granularity_sqla": "created_at", "groupby": [ "nuts_0_title", "nuts_1_title", "nuts_2_title", "programme_period_title", "programme_type_title" ], "include_time": false, "metrics": [ "sum_partnership_budgets", "count_distinct_partnerships" ], "order_by_cols": [], "order_desc": true, "percent_metrics": [], "queryFields": { "groupby": "groupby", "metrics": "metrics" }, "query_mode": "aggregate", "row_limit": 50000, "show_cell_bars": true, "table_timestamp_format": "smart_date", "time_grain_sqla": "P1D", "time_range": "No filter", "time_range_endpoints": [ "inclusive", "exclusive" ], "timeseries_limit_metric": { "aggregate": "COUNT_DISTINCT", "column": { "column_name": "nuts_0_title", "description": null, "expression": null, "filterable": true, "groupby": true, "id": 338, "is_dttm": false, "optionName": "_col_nuts_0_title", "python_date_format": null, "type": "VARCHAR(255)", "verbose_name": "NUTS0" }, "expressionType": "SIMPLE", "hasCustomLabel": false, "isNew": false, "label": "COUNT_DISTINCT(nuts_0_title)", "optionName": "metric_1d9rs77igvh_o02ry79auz", "sqlExpression": null }, "url_params": {}, "viz_type": "table" }
Description None
Cache Timeout None
Perm [keep_statistics].[superset_partnerships](id:13)
Schema Perm None
Alerts []
Dashboards [Rafael_tests, Minimal Dashboard copy]
Email Schedules []