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
Name | DataType | List Options | Description |
---|---|---|---|
type | list | Lunch Break All breaks | The type of event you want to count |
starting | list | Start of segment Start of day Start of week | When to start counting the occurrences |
ending | list | End of segment End of day Hours into segment Hours into day Hours into week | When to stop counting number of occurrences |
hours | float | When counting occurrences and stopping after a number of hours per segment, day or week, this is the number of hours |