Count items where date is max

Hello everybody,  I have an interesting problem and need your help. Use Case: Imagin, you get a list of ticket changes. A Ticket can be in the status "to do", "doing" and "done". You receive a...