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

Name

Value

Opt.

Description

Example

Identifier

System.Object

opt.

Which columns are to be evaluated for identifiers, by which calculations are performed separately.

-

Date + time (from)

System.DateTime

-

Column containing the start (date+time) of the time period.

-

Date + time (to)

System.DateTime

-

Column containing the end (date+time) of the time period.

-

Summarized by

System.Double

-

Column whose values are used for the 'summarized by' calculation.

-

Settings

Name

Value

Opt.

Description

Example

Totals field

System.String

  • Minimum
  • Maximum
  • Average
  • Median
  • 1st Quartile
  • 3rd Quartile
  • Percentile 90%
  • Percentile 95%
  • Percentile 98%
  • Percentile 99%
  • Standard deviation
  • Variance
  • On average: at least 1 person
  • On average: at least 2 persons
  • On average: at least 3 persons
  • On average: at least 4 persons

-

Which statistical function should be applied to the data? (median, average, etc...)

-

Weekdays

System.String

  • All
  • Monday-Friday
  • Monday - Thursday
  • Saturday-Sunday
  • Friday-Sunday

-

Weekdays which are evaluated.

-

Want to learn more?

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

Examples

Example: Create pivot table

Situation

Operation setting



Result

TIS Project

-


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