My Reports – Pivoting

Pivoting the Grid

The reporting tool in Albert allows you to build pivot tables and even pivot charts just as you would in a program like Excel. Pivoting allows you to take a column's values and turn them into columns. In the present example, three types of measurements have been carried out for each sample Inventory according to albert's naming conventions:

• Rotational viscosity,
• pull-off strength measurements and
• heat flow calorimetry.

Pivoting only makes sense when mixed with aggregation. If you turn a column into a pivot column, you must have at least one aggregation (value) active for the configuration to make sense.

Pivot Mode

Pivot mode is required to be turned on for pivoting to work. You can activate Pivot Mode by selecting the toggle in the upper right hand portion of the screen starting out from the initial screen after selecting your report type of choice. 

When the grid is in pivot mode, the following will happen:

• • • • Only columns moved to the fields Row Groups, Values and Column Labels via drag and drop will be included in the grid.
      • Only aggregated rows will be shown, the lowest level row data will not be displayed.
      • If pivot mode is off, then adding or removing pivot columns will have no effect.

Pivoting

The example below shows a simple pivot on the column named Data Column.

In order to generate the pivot table below, the available columns have be sorted accordingly:

• Inventory Name as Row Groups for definining the rows of the resulting table.
• Data Column as Column Labels will pick the entries from the Data Column column and use them to define the columns of the new table.

With these to steps, we already "spanned" the new tabular structure based on existing experimental values. What's still missing at this point the the values populating this table. Therfore, we need to set

• the Data Point column as Values.

*Please note that the explanations are names valid for the 'Results Average Data' report template*

Pivot Charts

Pivot Chart allow users to chart all grouped and pivoted data from inside the grid. When pivot mode is active in the grid, the pivot chart menu item will appear in the grid's context menu (right-click anywhere in the pivot table area).

From here, select the desired chart type from the 'Pivot Chart' sub menu. In our case, we would like to obtain a scatter plot of 

• Peak Position on the x-axis vs.
• Pull-off Strength on the y-axis.

Initially, we end up with the following:

To arrive at the final plot we had in mind, we need to restrict to the the two target columns via filtering an reorder them appropriately via drag and drop of the columns.