Summary

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.

Configuration

Input settings of existing table

Settings

Want to learn more?

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

Examples

Example: Create pivot table

Troubleshooting

• 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

• Operators (alphabetical overview)
• This operation is often used to further process the results of Scaling 8.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 Resolve pivot table 2.0.