Sum and count
Summary
Time intervals are assigned to calendar periods (e.g. per month, per quartile) and the following analyses are supported:
 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
 Summation of values – ‘’e.g. 30 € + 20 € turnover on day X: equals 50 € on day X
 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 "FromDate/FromTime/ToTime", 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?
Settings
Time periods are set in a specific scale (e.g. Per month, per quarter).
Columns of input table
Parameter
Examples
Example 1: Sum (value)
Situation  

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

The following settings … 

…yield the following result  


[edit] Example 2: Sum (Time period x value)
Situation  
The following input record shall be analysed for summation (time period x value):

The following settings … 
…yield the following result  

[edit] Example 3: Sum events
Situation  
The following input record shall be analysed for the summation of events:

The following settings … 
…yield the following result  
For Count events the setting Time unit has no influence. 
[edit] Example 4: Count events
Situation  
The following input record shall be analysed for counting events:

The following settings … 
…yield the following result  
For Count events the setting Time unit has no influence. 
Note: Find more details about the calculation method under Grundbegriffe:Zeitperioden auf Kalenderperioden zuteilen
Troubleshooting
Problem  Frequent Cause  Solutions 

... 
 ... 
Related topics
 ...