Skip to main content

OCCURRENCES

Count the number of occurrences of an event during a timeline. For example, the number of breaks taken during a shift, or segment of time.

Example Usage

OCCURRENCES("All breaks", "Start of day", "Hours into current day", 5.0) -> California first lunch taken by hour five

Overview

Function signature
OCCURRENCES(type, starting, ending, hours)

Category
Calculated

Return data type
int

Arguments

NameDataTypeList Options                          Description
typelistLunch
Break
All breaks
The type of event you want to count
startinglistStart of segment
Start of day
Start of week
When to start counting the occurrences
endinglistEnd of segment
End of day
Hours into segment
Hours into day
Hours into week
When to stop counting number of occurrences
hoursfloatWhen counting occurrences and stopping after a number of hours per segment, day or week, this is the number of hours