I had a hard time putting the question title together but essentially I want to create a view like this:
ALTER VIEW vPlaceStatistics AS SELECT COUNT (TypeID) as Count, TypeID FROM PlaceStatistics GROUP BY TypeID
...which works great, but there is a Date field (mydatefield) on the table that I want to be able to use as a filter in my view.
If include mydatefield in my view then it creates record for each date whereas I want it to create one for each TypeID.
Essentially, I want my view to have access to the date field without it being part of the group by, if that is the right way to do it.