Summary

Time intervals are assigned to calendar periods (e.g. per month, per quartile) and the following analyses are supported:

  1. Summation of durations (if necessary weighted by value)- “e.g. 3 persons present for 4 hrs on day X: equals 12 hrs on day X
  2. Summation of values – ‘’e.g. 30 € + 20 € turnover on day X: equals 50 € on day X
  3. Counting – ‘’e.g. 30€ + 20€ sales volume on day X: equals 2 sales on day X

Configuration

Input settings of existing table

Settings


Remarks

  • This operation requires the data to be converted to a standardised time format: Please refer to Convert "From-Date/From-Time/To-Time"
  • Please also refer to Operation Scaling, which allows similar calculations for shorter time intervals (e.g. employees present from 2 pm to 2,30 pm on day X).
  • Several columns with numbers can be summarized at the same time (e.g. when several number columns are summarized).


Want to learn more?

Time periods are set in a specific scale (e.g. Per month, per quarter).

Examples

Example: Sum (value)

Situation

The following input record shall be analysed for summation (value):

From

To

Number of employees

2007/03/31 22:00

2007/04/01 06:00

2

Settings

Result

From

To

Description

Number of employees

2007/03/31 00:00:00

2007/04/01 00:00:00



2007/04/01 00:00:00

2007/04/02 00:00:00


2,00

Project File

-

Example: Sum (Time period x value)

Situation

The following input record shall be analysed for summation (time period x value):

From

To

Number of employees

Value

2007/03/31 22:00

2007/04/01 06:00

2

10

Settings

Result

From

To

Description

Number of employees

Value

2007/03/31 00:00:00

2007/04/01 00:00:00




2007/04/01 00:00:00

2007/04/02 00:00:00


16,00

80,00

Project File

-

Example: Sum events

Situation

The following input record shall be analysed for the summation of events:

From

To

Number of employees

Value

2007/03/31 22:00

2007/04/01 06:00

2

10

Settings

Result

For Count events the setting Time unit has no influence.

Project File

-

Example 4: Count events

Situation

The following input record shall be analysed for counting events:

From

To

2007/03/31 22:00

2007/04/01 06:00

Settings

Result

From

To

Description

Result

2007/03/31 00:00:00

2007/04/01 00:00:00


0,25

2007/04/01 00:00:00

2007/04/02 00:00:00


0,75

For Count events the setting Time unit has no influence.

Project File

-


Troubleshooting

Nothing known up to now.


Related topics