I am trying to make a chart of how many support cases I have recieved and how many I have solved on a weekly basis.
I have the fields Case_Id, Submit_Date and Resolved_Date. Based on the 2 dates I have created to temp. calendars where I have the Submit_YearWeek and Resolved_YearWeek.
I would believe that I somehow needs to created a table with YearWeek, No of submitted cases, No of Resolved cases, but I have no idea on how to create this.
