Finding status incident at a particular time

Content

Hi,

I have created a report where incidents join onto transactions so I can see what status a incident was (please see attached).

My question is given a date as a filter, how would I bring back a number to say X incidents had a status Y at date Z. In the example I had 5 incidents. Let's say I wanted to know the above for the date 20/04/2017 I could see

• Resolved at Tier 2 = 3
• Resolved at Tier 1 = 1
• New = 1

However if I passed the date 01/08/2017 I would have

• Resolved at Tier 1 = 2
• Resolved at Tier 2 = 3

Something like showing the maximum date for a given reference?