This is an issue I attempting to solve and haven't been able to find any resources on. I'd like community feedback on how best to solve this scenario.
Scenario: I need a daily count of open IT Tickets 10 days or older. I'm given a unique ticket number, creation date, and resolution date.
Example Table:
| TicketNumber | CreationDate | ResolveDate |
| 45100 | 11/1/2022 | 11/16/2022 |
| 45145 | 11/2/2022 | 11/11/2022 |
| 45186 | 11/2/2022 | 11/13/2022 |
| 45187 | 11/2/2022 | 11/12/2022 |
| 45227 | 11/3/2022 | 11/11/2022 |
| 45304 | 11/3/2022 | 11/12/2022 |
| 45347 | 11/3/2022 | 11/17/2022 |
| 45378 | 11/3/2022 | 11/13/2022 |
| 45419 | 11/4/2022 | 11/17/2022 |
| 45423 | 11/4/2022 | 11/9/2022 |
| 45497 | 11/4/2022 | 11/9/2022 |
| 45515 | 11/5/2022 | 11/14/2022 |
| 45588 | 11/7/2022 | 11/13/2022 |
| 45600 | 11/8/2022 | 11/17/2022 |
| 45700 | 11/8/2022 | 11/15/2022 |
| 45711 | 11/8/2022 | 11/21/2022 |
| 45716 | 11/9/2022 | 11/19/2022 |
| 45743 | 11/10/2022 | 11/23/2022 |
| 45747 | 11/12/2022 | 11/17/2022 |
| 45785 | 11/13/2022 | 11/28/2022 |
| 45797 | 11/13/2022 | 11/25/2022 |
| 45804 | 11/13/2022 | 11/24/2022 |
| 45849 | 11/15/2022 | 11/24/2022 |
| 45869 | 11/16/2022 | 11/29/2022 |
| 45939 | 11/17/2022 | 11/25/2022 |
| 45980 | 11/19/2022 | 12/3/2022 |
| 45983 | 11/19/2022 | 11/28/2022 |
| 45984 | 11/20/2022 | 12/2/2022 |
| 45990 | 11/20/2022 | 11/26/2022 |
Expected Result:
| AgedTicket_Ct | Date |
| 0 | 11/1/2022 |
| 0 | 11/2/2022 |
| 0 | 11/3/2022 |
| 0 | 11/4/2022 |
| 0 | 11/5/2022 |
| 0 | 11/6/2022 |
| 0 | 11/7/2022 |
| 0 | 11/8/2022 |
| 0 | 11/9/2022 |
| 0 | 11/10/2022 |
| 1 | 11/11/2022 |
| 2 | 11/12/2022 |
| 3 | 11/13/2022 |
| 3 | 11/14/2022 |
| 3 | 11/15/2022 |
| 3 | 11/16/2022 |
| 2 | 11/17/2022 |
| 1 | 11/18/2022 |
| 1 | 11/19/2022 |
| 2 | 11/20/2022 |
| 2 | 11/21/2022 |
| 1 | 11/22/2022 |
| 4 | 11/23/2022 |
| 3 | 11/24/2022 |
| 2 | 11/25/2022 |
| 2 | 11/26/2022 |
| 2 | 11/27/2022 |
| 2 | 11/28/2022 |
| 2 | 11/29/2022 |
| 2 | 11/30/2022 |
| 2 | 12/1/2022 |
| 2 | 12/2/2022 |
| 1 | 12/3/2022 |
