Pivot tables

Pivot tables can be run for a result of a query. If for example we search for all projects starting in 2018-2024 we can use the query answer as an input for the project pivot:

Open

Having defined rows, colums and aggregate we can get a table of all projects over the years with the specified University role:

Open

Open

or in the graphical form:

Open

By adding the column Budget we get another table

Open

To analyze the structure of projects by funders, you just change the definition of rows, removing WUT role and drug- and-drop the attribute Contracting Authotity from the list of available attributes, instead:

Open

Open