Hi @JayasuryaJ,
1.Create a Calculated Field:
Business Rule script:
(function executeRule(current, previous /*null when async*/) {
var ageInDays = gs.daysAgo(current.opened_at);
if (ageInDays > 60 && ageInDays <= 90) {
current.u_age_interval = '2-3 Months';
} else if (ageInDays > 90 && ageInDays <= 120) {
current.u_age_interval = '3-4 Months';
} else if (ageInDays > 120 && ageInDays <= 150) {
current.u_age_interval = '4-5 Months';
} else if (ageInDays > 150) {
current.u_age_interval = 'Over 5 Months';
} else {
current.u_age_interval = 'Less than 2 Months';
}
current.update();
})(current, previous);
2.Create or Modify the Report:
- Go to the Reports module.
- Create a new report or modify the existing one.
- Set the type of report to a bar chart or a similar type that allows X and Y-axis customization.
- Set the data source to the table where your tickets are stored (e.g., incident).
- For the X-axis, select the newly created u_age_interval field.
- For the Y-axis, you can select a count of the tickets.
3.Group and Aggregate Data:
- In the report configuration, ensure you are grouping by the u_age_interval field.
- Use the count aggregation to show the number of tickets in each aging interval.
4.Run and Save the Report:
- Run the report to visualize the tickets grouped by the aging intervals.
- Save the report for future use and share it with the relevant stakeholders.
Thank you, please make helpful if you accept the solution.
