Historical reporting on average Age of Incidents in Q

Content

Hi,

I have a requirement to report on historical values for Average Age of Incidents in a Q and cannot wrap my mind around it.

Has anyone done anything similar? I know how to report it for incidents currently in the Q, but how do I do it for e.g. last week/day - how old were the incidents in the Q on each day of last week ? I cannot simply add the date range to the current report as that will only show me the incidents that are still there.

Many thanks

Pavol