Column | Verbose Name | Type | Groupable | Filterable | Is temporal | |
---|---|---|---|---|---|---|
investment_priority | None | VARCHAR(670) COLLATE UTF8MB4_UNI | ||||
investment_priority_id | None | SMALLINT(10) | ||||
nuts_0 | None | VARCHAR(255) COLLATE UTF8MB4_UNI | ||||
nuts_0_id | None | SMALLINT(10) | ||||
nuts_1 | None | VARCHAR(255) COLLATE UTF8MB4_UNI | ||||
nuts_1_id | None | SMALLINT(10) | ||||
nuts_2 | None | VARCHAR(255) COLLATE UTF8MB4_UNI | ||||
nuts_2_id | None | SMALLINT(10) | ||||
nuts_3 | nuts_3 | VARCHAR(255) COLLATE UTF8MB4_UNI | ||||
nuts_3_id | nuts_3_id | SMALLINT(10) | ||||
period | None | VARCHAR(255) COLLATE UTF8MB4_UNI | ||||
period_id | None | SMALLINT(10) | ||||
program_type | None | VARCHAR(255) COLLATE UTF8MB4_UNI | ||||
program_type_id | None | SMALLINT(10) | ||||
programme_name | None | VARCHAR(255) COLLATE UTF8MB4_UNI | ||||
programme_name_id | None | SMALLINT(10) | ||||
thematic | None | VARCHAR(255) COLLATE UTF8MB4_UNI | ||||
thematic_id | None | SMALLINT(10) | ||||
thematic_objective | None | VARCHAR(670) COLLATE UTF8MB4_UNI | ||||
thematic_objective_id | None | SMALLINT(10) | ||||
thematic_priority | Thematic Priority | VARCHAR(900) COLLATE UTF8MB4_UNI | ||||
thematic_priority_id | thematic_priority_id | SMALLINT(10) |
Metric | Verbose Name | Type | |
---|---|---|---|
sum__period_id | None | sum | |
sum__thematic_id | None | sum | |
sum__investment_priority_id | None | sum | |
sum__nuts_0_id | None | sum | |
sum__thematic_objective_id | None | sum | |
sum__nuts_1_id | None | sum | |
sum__program_type_id | None | sum | |
sum__nuts_2_id | None | sum | |
sum__programme_name_id | None | sum | |
count | COUNT(*) | count | |
avg__period_id | None | avg | |
avg__nuts_2_id | None | avg | |
avg__programme_name_id | None | avg | |
avg__nuts_1_id | None | avg | |
avg__program_type_id | None | avg | |
avg__nuts_0_id | None | avg | |
avg__thematic_objective_id | None | avg | |
avg__thematic_id | None | avg | |
avg__investment_priority_id | None | avg |
Table Name | superset_legacy_filters |
---|---|
Sql | None |
Enable Filter Select | False |
Fetch Values Predicate | None |
Database | keep_statistics |
Schema | None |
Description | None |
Owners | [] |
Main Datetime Column | None |
Default Endpoint | None |
Offset | 0 |
Cache Timeout | 1 |
SQL Lab View | False |
Template parameters | None |
Extra | None |
Perm | [keep_drupal_staging].[superset_legacy_filters](id:6) |
Associated Charts | [One or more programmes, NUTS0 (country), One or more programming periods, One or more programme type, Thematic Objectives, Investment Priorities, NUTS1 (region of the country), NUTS2 (further regional division), Thematic priorities, Programmes, Programme types, Thematic Objectives, Investment Priorities, Thematics, NUTS0 (countries), NUTS1 (regions of the countries), NUTS2 (further regional divisions), Programming periods, NUTS3 (smaller regions)] |