Rolling Time
- DarkLight
Rolling Time
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Rolling Time operators enable you to segment date and time fields based on a dynamic time window measured in hours or minutes, relative to the current moment. After selecting Rolling Time as the operator and the corresponding option, the criteria enables the Value text box, where you type the required numeric value. You can also choose Hours or Minutes, with Hours selected by default.
Note:
The allowed values for hours and minutes have defined minimum and maximum limits:
Hours: Minimum: 1 hour | Maximum: 168 hours (1 week)
Minutes: Minimum: 30 minutes | Maximum: 1,440 minutes (1 day)
The following table explains the Additional Criteria for the Rolling Time operator, the Value and Unit inputs, and their examples.
Additional Criteria for the Rolling Period Operator | Period | Unit | Example |
|---|---|---|---|
Within Past | 3 | Hours | Onboarding Date Time is within past 3 hours, which means the Onboard Date falls between January 1, 2024, 12:00 PM and January 1, 2024, 3:00 PM, assuming the current time is January 1, 2024, 3:00 PM. |
Within past | 45 | Minutes | Onboarding Date Time is within past 45 minutes, which means the Onboard Date falls between January 2, 2024, 8:15 AM and January 2, 2024, 9:00 AM, assuming the current time is January 2, 2024, 9:00 AM. |
Within next | 6 | Hours | Onboarding Date Time is within next 6 hours, which means the Onboard Date falls between January 1, 2024, 3:00 PM and January 1, 2024, 9:00 PM, assuming the current time is January 1, 2024, 3:00 PM. |
Within next | 45 | Minutes | Onboarding Date Time is within next 45 minutes, which means the Onboard Date falls between January 2, 2024, 9:00 AM and January 2, 2024, 9:45 AM, assuming the current time is January 2, 2024, 9:00 AM. |
More than | 2 | Hours | Onboarding Date Time is more than 2 hours ago, meaning the Onboard Date Time must be earlier than January 1, 2024, 1:00 PM, assuming the current time is January 1, 2024, 3:00 PM. |
More than | 45 | Minutes | Onboarding Date Time is more than 45 minutes ago, meaning the Onboard Date Time must be earlier than January 2, 2024, 8:15 AM, assuming the current time is January 2, 2024, 9:00 AM. |
Less than | 4 | Hours | Onboarding Date Time is less than 4 hours ago, meaning the Onboard Date Time must be later than January 1, 2024, 11:00 AM and no later than January 1, 2024, 3:00 PM, assuming the current time is January 1, 2024, 3:00 PM. |
Less than | 30 | Minutes | Onboarding Date Time is less than 30 minutes ago, meaning the Onboard Date Time must be later than January 2, 2024, 8:30 AM and no later than January 2, 2024, 9:00 AM, assuming the current time is January 2, 2024, 9:00 AM. |
Was this article helpful?