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

Name

Value

Opt.

Description

Example

Identifier

System.Object

opt.

Which columns should be evaluated for the identifier?

-

Date + time (from)

System.DateTime

-

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

-

Date + Time (to)

System.DateTime

-

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

-

Calculate totals field

System.Object

opt.

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

-

Settings

Name

Value

Opt.

Description

Example

Scaling

System.String

  • Calendar days
  • Calendar weeks
  • Calendar months
  • Quarter
  • Half years
  • Calendar years
  • Total period

-

Scaling specification, e.g. Weeks, months...

-

Calculation method

System.String

  • Breakdown of hours
  • More than 50% in period
  • Start time in period
  • End time in the period

-

Selection of how the time interval is allocated.

Example calculation method 'Allocation of the hours':
Calendar month, Shift 22:00 to 6:00. 2 hours fall in the fist month. 6 hours fall in the second month.

-

Totals field

System.String

  • Sum (duration x value)
  • Sum (value)
  • Count events

-

Which function should be applied to the data? (add up hours or events)

-

Time Unit

System.String

  • Minutes
  • Hours
  • Days
  • Weeks

-

Select the time unit in which the time span of the data are to be calculated (hours, days...)

-


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