Aggregate and distinct mode

Hi everyone,

First I want to say that I am very beginner with Drupal. I spent a lot of hours trying to solve my problem but I haven't been able to find/do anything.

Here is the situation (I am also using Rules and Message) :

I have a content type for clients. Each client can have a status "client" or "prospect".
I created a rule to create a message each time the status is created or edited. This parts work fine. With this I am able to track everything going on with the client's status and have an historic of that. The message contain the timestamp, the title of the client and the status : "2013-05-16 22pm : Company 1 has been set to Client".
After that, I want to create a view to count how much client and prospect do I have. And I want to be able to select a date in the filter the see the count at different time (this is also working).

The problem I have is with my counting :

For example if I have two events with the company 1 :

2013-03-12 3pm : Company 1 has been set to Prospect
2013-05-16 10pm : Company 1 has been set to Client

This mean that when I see my view with no filter (a view of 'message') I want to see the count like this :
Client : 1
Prospect : 0

And if I add a filter for the date 2013-04-15, I want to see :
Client : 0
Prospect : 1

This is an example with one client but it could be hundreds.

For now, with no filter, the only thing I can have is :
Client : 1
Prospect : 1

I can't manage to use the distinct mode and keep the most recent date. I tried the module "views distinct" but I am not able to make the counting to work with this module.

I hope I was clear enough. If someone has any idea on how to make this work, it would be very helpful. I really don't know where to look at anymore.

Thank you,

Eddy