TABLE OF CONTENTS
- Datamining Tiers – Time In Process
- How to Add Time In Process
- What the Time In Process Tier Adds
- Time In Process Panel
- Time In Process – Canonical Rules
- Time In Process – Frequently Asked Questions
- Common Support Scenarios
Datamining Tiers – Time In Process
The Time In Process tier pivots Process history for a module (Applications, Users, Devices, etc.) into reportable time-based metrics.
It calculates how long an item has spent in each Process or Process Status and is commonly used to identify items that are stalled, breaching SLAs, or taking longer than expected to progress.
How to Add Time In Process
To add the Time In Process tier:
- Click Add Time In Process in the ribbon menu.
- The Time In Process tier is added to the report.
Only one Time In Process tier can be added to a report. This is a system limitation due to the complexity of calculating and presenting multiple time-based pivots.
What the Time In Process Tier Adds
The Time In Process tier adds a set of calculated columns based on the selected display mode and time unit.
Depending on configuration, the tier includes:
- Time spent in each Process or Process Status
- Total time across all included Processes or Statuses
- Current time in the active Process (where applicable)
- A Unit column describing the time measurement
The Unit column is always included, as a display mode is required and all modes produce a unit-aware result.
Time In Process Panel
Display Mode
Group on Status (Default)
Adds columns for each Process Status:
- Inactive
- In Progress
- On Hold
- Ready
- Out of Scope
Time is aggregated across all Processes that share the same status. A Total and Unit column are also included.
Group on Processes
Adds columns for each Process defined for the selected module.
Each column shows the time spent in that specific Process, along with:
- Total – total time across all included Processes
- Current – time spent in the current Process only
- Unit – time measurement unit
The Current value respects all working day rules, date limits, and exclusions.
Full List
Displays Process history as rows instead of columns.
Each row represents a Process visit for the item. Only Processes that were actually visited are included.
The following columns are added:
- Process
- Sub Process
- Status
- Time In Process
- Unit
Time In Process Unit
24h Days
Counts the number of 24-hour days (including fractions) an item spent in a Process.
Working Day settings are ignored in this mode.
Work Days (Default)
Counts the number of working days an item spent in a Process or Status.
A working day is defined by the configured Working Day Start and End times, excluding non-working days and dates.
Hours
Counts the number of hours (including fractions) spent in a Process.
Only time within the defined working day window is counted.
Minutes
Counts the number of full minutes spent in a Process.
Time outside the defined working day window is not counted.
Working Day Settings
Start / End Time
Defines the working day window. The default is 8:00 AM to 5:00 PM.
Time outside this range is excluded when using Work Days, Hours, or Minutes.
Limit to Specific Dates
Allows readiness calculations to be limited to a specific date range.
If an item entered a Process before the From date or exited after the To date, only the overlapping time within the range is counted.
Process Statuses to Exclude
You can exclude one or more Process Statuses from the calculation:
- Inactive
- In Progress
- On Hold
- Ready
- Out of Scope
No statuses are excluded by default.
Excluded statuses are removed entirely from the calculation and do not contribute to totals.
Days of the Week to Exclude
Allows specific days of the week to be excluded from calculations.
Saturday and Sunday are excluded by default.
Dates to Exclude
Specific dates or date ranges (such as public holidays) can be excluded.
- Add Exclude Date
- Add Exclude Date Range
Excluded dates are listed and can be individually removed.
Time In Process – Canonical Rules
- Time In Process is calculated from historical Process transitions.
- Process Status is a property of Process and cannot change independently.
- When grouping by Status, time is aggregated across all Processes with the same status.
- Only time overlapping the selected date range is counted.
- Excluded statuses and dates are discarded entirely and do not contribute to totals.
- Only one Time In Process tier can exist in a report.
Time In Process – Frequently Asked Questions
Why does the time seem lower than expected?
Time may be reduced due to working day limits, excluded dates, excluded days of the week, or Process Status exclusions.
Why does time reset when an item changes Process?
Time is tracked per Process visit. Each transition to a new Process starts a new time segment.
Why is Out of Scope time missing?
If Out of Scope is excluded in the panel, all time spent in Out of Scope Processes is discarded.
Why do I see multiple rows for the same item in Full List mode?
Full List mode generates one row per Process visit, including Sub Process information.
What does the Current column represent?
Current shows the time spent in the item’s current Process only, respecting all working day rules, exclusions, and date limits.
Can I compare Time In Process across different units?
No. Each report uses a single Time In Process unit defined in the panel.
Common Support Scenarios
Scenario: Identifying items stuck in a Process
Use Group on Processes and sort by the Current column to identify items that have remained in a Process longer than expected.
Scenario: SLA reporting by Status
Use Group on Status to aggregate time across all Processes that share the same status.
Scenario: Month-over-month comparison
Run separate reports with different date ranges to compare Time In Process across periods.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article