Time-related data are converted to a pivot table time x weekdays allowing some calculations.

E.g. What is the average number of employees present on certain days of the week at certain times of the day.

Example: Create pivot table


Operation setting


TIS Project


Want to learn more?


Analysis of data using pivot table of time x week days.

Columns of input table



  • Data have to be in format "TimeRaster" (configure during import)
  • Identifier is not available to choose, but it is shown in the operation settings

Related topics

This operation is often used to further process the results of Scaling 7.0.

The results of this operation are often further processed with Chart: Histogram Time Pattern.

To go the opposite way, i.e. to go back from the pivot structure to standard format, use Pivottabelle auflösen.