Overview
The Selected Cases Over Time calculator shows how the count or sum of filtered cases changes across time periods. This calculator helps you track trends in case volumes, identify patterns, and monitor how specific subsets of cases evolve over time.
Common Uses
- Monitor filtered case volumes over time
- Track cases with specific characteristics across time periods
- Identify seasonal patterns in selected cases
- Compare absolute numbers vs. rates over time
- Analyze trend changes in specific case segments
Settings
Date Attribute: Select the date/time attribute that will represent the base for time period calculation (e.g., Case Start Date, Case End Date, or Activity Time).
Activity Name: If you selected Activity Time as your Date Attribute, specify which activity's timestamp to use for the time-based analysis.
Activity Selection Type: If using Activity Time, choose whether to use the first or last occurrence of the selected activity in each case.
Over Time Period: Select the time period granularity for analysis (Daily, Weekly, Monthly, Quarterly, Yearly).
Aggregate Function: Choose how to aggregate the data:
- Case count: Count the number of filtered cases in each time period
- Sum: Sum values from a selected attribute for filtered cases in each time period
Value Attribute: If using Sum as the aggregate function, select which numeric attribute to sum.
Select cases in which: Define the filter criteria to select which cases to include in the analysis (e.g., cases with specific status, duration thresholds, or attribute values).
Example
Tracking Long Duration Cases Over Time
Scenario: You want to monitor how many cases with durations over 30 days occur each month to track process performance improvements.
Settings:
- Date Attribute: Case Start Date
- Over Time Period: Monthly
- Aggregate Function: Case count
- Select cases in which: Case Duration > 30 days
Output:
The calculator displays a time-series chart showing:
- X-axis: Time periods (months)
- Y-axis: Number of cases exceeding 30 days duration
- Trend line showing whether long-duration cases are increasing or decreasing
Insights: You might discover that long-duration cases decreased after implementing a new approval workflow, or that they spike during specific months, indicating seasonal bottlenecks.
Output
The calculator provides:
- Line chart: Visual trend of selected case volumes over time
- Bar chart: Period-by-period comparison
- Grid view: Detailed numerical data for each time period
- Trend indicators: Visual cues showing increases or decreases
This documentation is part of the mindzie Studio process mining platform.