Interval Summary
The Interval Summary object consolidates closed intervals into one row per period, tracked object, tracked field, value, and owner, with counts and the sum, average, minimum, and maximum minutes. Day rows are built nightly and rolled into Month rows; purge keeps them when it deletes intervals. Commonly used for leaderboards, trends, and long-term reporting.
API name: Interval_Summary__c
| Field | API name | Type | Description |
|---|---|---|---|
| Avg Business Minutes | Avg_Business_Minutes__c |
Number (16, 2) | Average business minutes per interval. |
| Avg Calendar Minutes | Avg_Calendar_Minutes__c |
Number (16, 2) | Average calendar minutes per interval. |
| Breach Count | Breach_Count__c |
Number (9, 0) | Intervals that breached their goal. |
| Granularity | Granularity__c |
Picklist: Day, Month | Whether the row covers one day or one month. Help text: Day rows are built nightly. Month rows replace day rows older than the roll-up window. |
| Interval Count | Interval_Count__c |
Number (9, 0) | Number of intervals summarised. |
| Max Business Minutes | Max_Business_Minutes__c |
Number (16, 2) | Longest interval in business minutes. |
| Max Calendar Minutes | Max_Calendar_Minutes__c |
Number (16, 2) | Longest interval in calendar minutes. |
| Min Business Minutes | Min_Business_Minutes__c |
Number (16, 2) | Shortest interval in business minutes. |
| Min Calendar Minutes | Min_Calendar_Minutes__c |
Number (16, 2) | Shortest interval in calendar minutes. |
| Owner Id | Owner_Id__c |
Text (18) | Owner during the summarised intervals. |
| Owner Name | Owner_Name__c |
Text (255) | Owner display name. |
| Owner Type | Owner_Type__c |
Picklist: User, Queue | Whether the owner was a user or a queue. Help text: User or Queue. |
| Owner User | Owner_User__c |
Lookup (User) | Owner as a user lookup for role and manager roll-ups. Help text: Set when the owner is a user. |
| Parent Object | Parent_Object__c |
Text (255) | API name of the tracked object. |
| Period Start | Period_Start__c |
Date | First day of the summarised period. Help text: The day, or the first day of the month, the summarised intervals closed in. |
| Record Count | Record_Count__c |
Number (9, 0) | Distinct tracked records among the intervals. |
| Sum Business Minutes | Sum_Business_Minutes__c |
Number (16, 2) | Total business minutes across the intervals. Help text: Total business minutes. |
| Sum Calendar Minutes | Sum_Calendar_Minutes__c |
Number (16, 2) | Total calendar minutes across the intervals. Help text: Total calendar minutes. |
| To Value | To_Value__c |
Text (255) | The value the summarised intervals held. |
| Tracked Field | Tracked_Field__c |
Text (255) | API name of the tracked field. |
| Unique Code | Unique_Code__c |
Text (255) | Granularity, period start, object, field, value, and owner joined by pipes; makes the upsert idempotent. Help text: Set by the summary job. |