Show Chart

Owners [Sofokus Admin]
Table superset_partnerships
Created By Sofokus Admin
Changed By Sofokus Admin
Created On 2019-12-16 20:47:27.723677
Changed On 2019-12-16 21:00:21.276419
Name Programmes, Partnerships, Projects, and Partnership budgets (2014-2020)
Datasource Id 13
Datasource Type table
Datasource Name superset_partnerships
Visualization Type table
Parameters { "adhoc_filters": [ { "clause": "WHERE", "comparator": "", "expressionType": "SIMPLE", "filterOptionName": "filter_uj5apnomind_n6nhe9ofuh", "fromFormData": true, "operator": "IS NOT NULL", "sqlExpression": null, "subject": "nuts_0_id" }, { "clause": "WHERE", "comparator": "", "expressionType": "SIMPLE", "filterOptionName": "filter_4whqgid7hw3_n0qg7q1juu", "fromFormData": true, "operator": "IS NOT NULL", "sqlExpression": null, "subject": "nuts_1_id" }, { "clause": "WHERE", "comparator": "", "expressionType": "SIMPLE", "filterOptionName": "filter_gn9orf9u5jv_4mhykfmpk08", "fromFormData": true, "operator": "IS NOT NULL", "sqlExpression": null, "subject": "nuts_2_id" }, { "clause": "WHERE", "comparator": "", "expressionType": "SIMPLE", "filterOptionName": "filter_tcmjszym0v8_vxtocgj22sj", "fromFormData": true, "operator": "IS NOT NULL", "sqlExpression": null, "subject": "nuts_3_id" } ], "align_pn": false, "all_columns": [], "color_pn": true, "datasource": "13__table", "granularity_sqla": "created_at", "groupby": [ "nuts_0_title", "nuts_1_title", "nuts_2_title", "nuts_3_title" ], "include_search": false, "include_time": false, "metrics": [ "count_distinct_programmes", "count_distinct_partnerships", "count_distinct_projects", "sum_partnership_budgets" ], "order_by_cols": [], "order_desc": true, "page_length": 0, "percent_metrics": [], "row_limit": 250, "slice_id": 344, "table_filter": false, "table_timestamp_format": "%Y-%m-%d %H:%M:%S", "time_grain_sqla": null, "time_range": "No filter", "timeseries_limit_metric": null, "url_params": {}, "viz_type": "table" }
Description None
Cache Timeout None
Perm [keep_statistics].[superset_partnerships](id:13)
Schema Perm None
Alerts []
Dashboards [Statistics Desktop]
Email Schedules []