Homepage

The FP7 Metric & Scoreboard online application is designed to present data related to the mapping European regional research & innovation capabilities by NUTS2 regions of EU Countries and several non–EU countries (Norway, Switzerland, Iceland and Serbia). Collected data is stored in database and could be search by online application, that has two main parts – Metric and Scoreboard Tools (which are linked to the Homepage with the Top Menu items dropping lists, Figures 1 & 2). To open desired dropping list, please move pointer to corresponding top menu item, wait for a dropping list and click on the desired tool link.


Figure 1. Homepage -Metric Menu dropping list Screenshot

Figure 2. Homepage - Scoreboard Menu dropping list Screenshot


Metric Tools Homepage

Introduction


There are two search modes – basic and advanced. Mapping tool is also present as additional visualization support.
In Basic search mode user could search for data in the scope of one indicator, one index and one unit.
In Advanced search mode, user could search the data in the scope of multiple indicators, with related indices and units. Advanced search mode also has additional calculation feature, which could be executed on search results, as well as additional graphical visualization.
As a third option, The mapping tool is presented with NUTS2 regional European map.
 

1. Application usage


Both search modes are organized in step-by-step manner in the following order: choosing the country, following by the corresponding Region, Indicator, Index and Unit, as well as the year of collected statistics.

1.1. Basic search form usage


As it was mentioned in introduction, Basic search mode usage is organized for search per one indicator, one index and one unit. A user could search the database in the order as follows:

Step 1: Choose the country of interest,
Step 2: Choose the Region that belongs to the chosen country,
Step 3: Choose the Indicator of the interest,
Step 4: Choose the corresponding index and unit that is related to the chosen indicator,
Step 5: Choose the starting year of collected statistics,
Step 6: Choose the ending year of collected statistics.

Selection is organized through the dropping lists. Choosing a parameter in the certain dropping list will dynamically generate other dropping lists of the other steps.

After selection of parameters through these 6 steps, Application automatically executes the search of the database and generates the results in the table located below the submission elements. Generated table could be exported to the MS Excel file by click on the Table Icon or corresponding text link (Figure 3).


Figure 3.
Export to MS Excel file link

NOTE: Excel file contains UTF-8 encoded data. This is not Microsoft default format and user could get message like one shown on the picture (Figure 4), while opening the file. This dialog is quite regular and it should be always responded with option “YES”.


Figure 4. Format-check Dialog



1.2. Advanced search form usage


Advanced search mode is organized for search per one or more indicators, indices and corresponding units. A user could search the database in the order as follows:

Step 1: Choose the country of interest,
Step 2: Choose the Region that belongs to the chosen country,
Step 3: Choose the Indicator of the interest,
Step 4:
Choose the corresponding index and unit that is related to the chosen indicator,
Step 5: Choose the years of collected statistics.

Selection is organized through the lists. Parameters could be chosen by clicking on one or more values (using CTRL or Shift while clicking).

After selection of parameters through these 5 steps, Application automatically executes the search of the database and generates the results in the table located below the submission elements.
Generated table could be exported to the MS Excel file by click on the Table Icon or corresponding text link (Figure 1), above the table. Advanced search mode also has additional calculation feature Denoted as Optional Step 6., which could be executed on search results. This could be activated by click on button located below the resulting table (Figure 5).


Figure 5. Additional calculation button

More details about this option could be found in Chapter 1.3.
NOTE: Excel file contains UTF-8 encoded data. This is not Microsoft default format and user could get message like one shown on the picture (Figure 4.), while opening the file. This dialog is quite regular and it should be always responded with option “YES”.

Also a one or more graphs that correspond to the generated table will be shown below the table. Graphics are contain dynamic legend, that highlights corresponding set of bars on click (Figure 6).


Figure 6. Dynamic legend - Highlighting bars

Graph could be saved by the right click ( Figure 7).

Figure 7. Save image option
After click on “Save Image” option, advanced dialog  with the  URL of the generated graph will be shown (Figure 8) . This could be copied to Clipboard in case there is no “Save image” option on the right-click menu and pasted in the Address bar in the new browser Tab or Window.

Figure 8. Advanced “Save image” dialog
NOTE: Graph generation option is not fully supported by Internet Explorer versions older than 9.0.

1.3. Additional Tabular calculations


Additional Tabular calculations could be executed on values located in columns of the generated table. Calculations could be executed using four basic mathematical operations (addition, subtraction, multiplication and division) by entered value or by values located in other columns.


Figure 9. Additional Tabular calculations
These calculations could be realised throuth the following procedure:
Step 1. Choose operator
Step 2. Choose “value” or field
Step 3. Enter value, if “value” in step 2 has been chosen. In a column which values should be modified, calculations are executed as follows:
1. User should choose appropriate operator from drop list
2. If values in a column should be modified by some constant value, in a Field-list option “value” should be chosen. Otherwise user should choose label of column which values are chosen for calculation (e.g. Field 2)
3. If field-list option “value” has been chosen, then appropriate number should be entered into Value-field.
Step 4. Steps 1, 2 or 3 should be repeated for each column which values are object of calculations.
Step 5. Button “Submit chosen calculations” should be activated.

Upon submission, chosen calculations are executed and new values should appear in the table, which is followed by modification of generated graphs below the table. All operations related to the mentioned graphs are the same as it was described earlier in Chapter 2.2.

1.4.  Spider Graph visualization Tool


Spider graph is additional visualization tool that graphically represents search results related with at least three regions, as well as minimum three metrics with non-all-zero data statistics captured from at least three statistical years. If these starting requirements are not fulfilled, resulting page would be generated with corresponding error message.
Pressing button Spider Graph Visualization will open another web page that contains basic visualization setup (Figure 10).

Figure 10. Basic spider graph options.

Basic visualization setup defines the way in which represented data should be organized and represented in resulting graphs. Setup contains three options (dropping lists of data types, located on the left side), as well as example spider graph that shows positions of certain data types (located on the right side, as shown in Figure 10).
Setup offers options to assign relations between different data types (Regions, Metrics and Years) and Spider graphical elements (Header (Data type1), Series (Data type 2) and Axis label (Data type 3)). This could be done by choosing desired data types on corresponding dropping lists.
For example, if setup is made in a way that statistical years are assigned to Data type 1 (Header would show statistical years), Metrics is assigned to Data type 2 (Series would show chosen indices and units) and finally, Regions is assigned to Data type 3 (Region names would be shown on corresponding graph axes), then resulting web page would generate spider graphs in a way that each if graphs presents normalized  values ratio between regions and different metrics, by corresponding statistical year (Figure 11).