See what status an incident was at a particular date

Content

Hi,

So we have a requirement to count how many incidents had a status X at time Y. What's the easiest way to do this? I just need a figure - nothing more.

My problem is that let's say we wanted to record everything prior to today (this date can be varied). Let's say we had 2,000 incidents that were "Updated" at 23:59 last night. We should have a figure of 2,000.

However if any of those 2,000 were resolved today (of course, presuming no others were created, other status changes didn't happen etc) then my report would being back 2,000 less any that were resolved.