Pivot tables (crosstabs) are used to display the following values of an analog value: minimum, maximum, average or difference.
Minimum, maximum and average are especially suitable for temperatures.
Differences is suitable for one, for example, water meter value.
For each evaluation the period is decisive. Hourly, Daily, Weekly, Monthly, Quarterly or Yearly.
For the evaluation, they can define pivot profiles, which are then used for quick retrieval of the data.