Hello all!
I need your help to find a solution for this matter. The idea is to calculate the average age of the tickets from my backlog per day. The average age must be in days (not in minutes or hours). Let me give you an example.
| TICKET NUMBER | CREATION DATE | END DATE |
| 40500 | 01/03/2019 8:45 | 04/03/2019 10:00 |
| 40501 | 02/03/2019 10:30 | 05/03/2019 11:00 |
| 40502 | 03/03/2019 12:05 | 06/03/2019 17:00 |
| 40503 | 04/03/2019 16:57 | 06/03/2019 16:00 |
This an example of a ticket table. I need to calculate de age of each tickets taking a date as a reference (DATE column).
| | | TICKET Age per day |
| DATE | AVERAGE BACKLOG AGE | 40500 | 40501 | 40502 | 40503 |
| 02/03/2019 0:00 | 0,635416667 | 0,6354 | | | |
| 03/03/2019 0:00 | 1,098958333 | 1,6354 | 0,5625 | | |
| 04/03/2019 0:00 | 1,029513889 | | 1,5625 | 0,4965 | |
| 05/03/2019 0:00 | 1,450925926 | | 2,5625 | 1,4965 | 0,2937 |
I need to obtain a formula to do the same calculus as I have in AVERAGE BACKLOG AGE column.
Maybe a temporal table would be the solution (I have one for the calculus of the number of tickets of backlog per day), but in this case I need to calculate the average age of the tickets from the backlog per day.
Any ideas? Thanks for your help as always 🙂
