Sum and count

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

This operation can only be applied to the following table types: (Tabellentyp) Duration, Time raster or Event

Configuration

Affected table sections

Date + time (from)
[Input] Column containing the beginning (date+time) of the time interval.
Columns must be of the type date+time.

Date + time (to)
[Input] Column containing the end (date+time) of the time interval.
Columns must be of the type date+time.

Totals field calculation
[Input] Columns from which the values for the calculation of the totals field are taken. Each column is analyzed individually.

Settings

Scaling
[Input] Determine time raster
Options: Calendar week, calendar weeks, calendar months, quarters, semesters, calendar years, total time

Calculation method
[Input] Selection of how time periods can be allocated. - ‘’e.g. How should a night shift be allocated to the two days concerned.
Options:

• Allocation of hours, ‘’pro rata – e.g. night shift from 10 pm to 6:00 am, 2 hrs allocated to day 1
• more than 50% in one period, ‘’majority – e.g. night shift from 10 pm to 6 am, 8 hrs allocated to day 2
• start time in one period,
• end time in one period

More details under Grundbegriffe:Zeitperioden auf Kalenderperioden zuteilen

Totals field
[Input] Which function should be applied to the data
Options: Sum (duration x value), Sum (value), Count events
More details under Examples Sum and count.

Time unit = Time unit of the result
[Input] Select the time unit in which the results of DURATION x VALUE shall be presented?
Options:Minutes, Hours, Days, Weeks
This selection only matters when the summation method duration * value is used. ‘’If the summation goes over e.g. 1 week, andthis week is divided into 6 time intervals of 10 hours each and the data value is 2, this would mean in hours: 6*10h*2 = 120 hours in days: 5 (5*24h = 120h), etc.”

Apply calculation to all numeric columns
[Input] If activated, the calculation is carried out for all numeric columns, regardless of the columns being selected for totals field calculation or not.If this option is activated, it overrides the manual selection of columns.

Please note

• This operation requires the data to be converted to a standardised time format: Please refer to Convert "From-Date/From-Time/To-Time", TIS:Umwandlung Datum/Uhrzeit and TIS:Umwandlung Pivot Datum/Zeitspalten
• 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).
• Please consider: TIS:Troubleshooting zu grosse Knoten
• Several columns with numbers can be summarized at the same time (e.g. when several number columns are summarized).

Want to learn more?

Related topics

• ...