Column | Verbose Name | Type | Groupable | Filterable | Is temporal | |
---|---|---|---|---|---|---|
budget | None | DOUBLE | ||||
investment_priority | None | VARCHAR(653) 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 | None | VARCHAR(255) COLLATE UTF8MB4_UNI | ||||
nuts_3_id | None | SMALLINT(10) | ||||
partner_id | None | INTEGER(11) | ||||
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_id | None | INTEGER(11) | ||||
programme_name | None | VARCHAR(255) COLLATE UTF8MB4_UNI | ||||
programme_name_id | None | SMALLINT(10) | ||||
project_id | None | INTEGER(11) | ||||
thematic | None | VARCHAR(255) COLLATE UTF8MB4_UNI | ||||
thematic_id | None | SMALLINT(10) | ||||
thematic_objective | None | VARCHAR(653) COLLATE UTF8MB4_UNI | ||||
thematic_objective_id | None | SMALLINT(10) |
Metric | Verbose Name | Type | |
---|---|---|---|
sum__thematic_objective_id | None | None | |
sum__thematic_id | None | None | |
sum__project_id | None | None | |
sum__programme_name_id | None | None | |
sum__programme_id | None | None | |
sum__program_type_id | None | None | |
sum__period_id | None | None | |
sum__partner_id | None | None | |
sum__nuts_3_id | None | None | |
sum__nuts_2_id | None | None | |
sum__nuts_1_id | None | None | |
sum__nuts_0_id | None | None | |
sum__investment_priority_id | None | None | |
sum__budget | None | None | |
count | COUNT(*) | None | |
avg__thematic_objective_id | None | None | |
avg__thematic_id | None | None | |
avg__project_id | None | None | |
avg__programme_name_id | None | None | |
avg__programme_id | None | None | |
avg__program_type_id | None | None | |
avg__period_id | None | None | |
avg__partner_id | None | None | |
avg__nuts_3_id | None | None | |
avg__nuts_2_id | None | None | |
avg__nuts_1_id | None | None | |
avg__nuts_0_id | None | None | |
avg__investment_priority_id | None | None | |
avg__budget | None | None | |
Number of Thematics | None | None | |
Number of Projects | None | None | |
Number of Programmes | None | None | |
Number of Partners | None | None | |
Aggregated Budget | None | None |
Table Name | superset_legacy_thematics1420 |
---|---|
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 | None |
SQL Lab View | False |
Template parameters | None |
Extra | None |
Perm | [keep_drupal_staging].[superset_legacy_thematics1420](id:7) |
Associated Charts | [Programmes per Thematic Objective per NUTS, Projects per Thematic Objective and Investment Priority, Projects per Thematic Objective and Programme Type, Partnerships per Thematic Objective, Partnerships per Thematic Objective and Programme Type, Budget per Thematic Objective and Programme Type, Budget per Thematic Objective and Investment Priority, Programmes per Programme Type and Thematic Objective, Programmes per Thematic Objectives and Investment Priority, Projects per Thematic Objective and per NUTS, Partnerships per Thematic Objective and NUTS, Budget per Thematic Objective and Programme Type, TEST] |