Capture Outstanding IT Ticket Count over Time Time

I have what I hope is an interesting problem for someone...   I'm tracking IT performance and am trying to capture the number of tickets open greater than 30 days over time. I'm struggling with the...