Has anyone every done aging analysis of the requests in this system? There does not appear to be any fields that track the number of days open for a request. I guess you would need to do some SQL for: today - opened time to get this?
eg. would like reports containing: 1) Open days for current cases (with columns <7days, 7-14 days 14-30 days, >30days etc). 2) Average age of open cases. 2) Number of days to close a case.
Has anyone done this? Would appreciate any advice.