How to group the data by date and type, so each entry would count as 1, from SQL Datasource?

[Bbyers3]

I have a date in my SQL database that I want to group the data by that date and Type. The Year/Month/Week/Day each entry would count as 1.

Example Dates

1/2/2018 - P
1/5/2018 - P
1/10/2018 - P
1/15/2018 - V
1/20/2018 - V
1/28/2018 - V

Should Produce

Jan - 6
Week 1 - 2P
Week 2 - 1V 1P
Week 3 - 1V
Week 4 - 1V