Hi All,
We have identified an issue while using Insights in a Constellation application and would appreciate guidance from the community and Pega.
Environment
• Pega Platform (Constellation) [25.1.2]
• Insight based on transaction data
• Aggregation configured using standard Insight functionality (Sum)
Business Requirement
Users can view aggregate totals (for example, Sum of Amount) at the bottom of the Insight table and expect the same summary values to be available when exporting the Insight to Excel.
Example visible within the Insight:
Sum = 24,660,858.01
Current Behaviour
Within the application:
• Insight displays aggregation values correctly.
• Footer totals are visible.
• Sum values are calculated accurately.
After Excel export:
• Transaction-level rows are exported successfully.
• Aggregation/footer totals are not included.
• The exported Excel file contains only detail records.
Expected Behaviour
The aggregation values already calculated and displayed within the Insight should also be present in the exported Excel output so users can reconcile totals without performing additional calculations.
Current Understanding
• The aggregation values are generated using Pega’s standard Insight aggregation feature.
• No custom calculation logic has been implemented.
• The values are available and displayed correctly in the UI.
• Only the export output appears to exclude these footer totals.
Questions
1. Is it expected behaviour that Insight footer aggregations are excluded from Excel exports?
2. Is there any OOTB configuration available to include aggregation/summary values in exported files?
3. Is this a known product limitation?
4. Has anyone encountered a similar issue in Constellation Insights?
5. Is this Defect already being addressed through a hotfix or product update?
Any guidance or confirmation from Pega or community members would be appreciated.
Thank you.
