Age Report of pending tickets of particular support group
Can someone help me to get the query to generate the report of all pending tickets of specific group along with the age of ticket and report with number of tickets in different priority like below
| Priority | 0-14 days | 15-30 days | 30-45 days | 45- 60 days | More than 60 days |
| Critical | |||||
| High | |||||
| Mediam | |||||
| Low | |
| Ticket ID | Technician | Requester | Status | Age |