So I have a table as follows:

```
Metric  Date         Site
GroupA  02/03/2015   Hector.com
GroupA  02/03/2015   Google.com
GroupB  02/03/2015   Hector.com
GroupB  02/03/2015   Booerns.org
GroupC  02/03/2015   abc.com
GroupA  02/04/2015   Jericho.org

```

And I need to get it into the following format. I exclude in my count any instance of `abc.com` in the Site column.

```
Metric  Date        Count
GroupA  02/03/2015      2
GroupB  02/03/2015      1
GroupA  02/04/2015      1

```

so essentially I would like to group all common Metrics together and count them for each day. The number of times a date appears should be equal to the distinct number of different metrics which appeared on that day. Additionally, if abc.com appears in the Site column, anywhere in the string (it can be like abc.com/bornhfuuen=email) it must not be counted