Performance Analytics - Cumulative Data collection
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
Hi everyone,
We are trying to create a dashboard that would show the cumulative data of Created Problems. What is the best approach to implement this task? We appreciate any suggestions and recommendations.
Thank you very much!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
Hi @DeGuzmanG ,
If you want to show the cumulative number of Problems created over time, I would recommend using Performance Analytics rather than a standard report.
For example, you can create a PA indicator based on the Problem [problem] table with:
- Indicator: Count of Problems
- Aggregation: Count
- Time series: Created/Opened date
- Cumulative: Enable the cumulative/rolling calculation in the visualization
This will give you a trend such as:
where each point represents the total Problems created up to that period.
If you only need a simple dashboard showing Problems created by month, a Platform Analytics Data Visualization using a time-series count may be sufficient. But if the requirement is specifically cumulative over time, PA is generally the better approach because it stores and calculates the historical indicator data.
I would also recommend clarifying whether "cumulative" means all Problems ever created or cumulative Problems within a particular year/period, as that will affect the indicator configuration.
