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 | LunchBreakAll breaks | The type of event you want to count |
starting | list | Start of segmentStart of dayStart of week | When to start counting the occurrences |
ending | list | End of segmentEnd of dayHours into segmentHours into dayHours 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 |