0 Replies Latest reply: Oct 19, 2011 11:29 AM by ravnholt RSS

    Creating a calculated table?

      Hi,

      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.

      Thanks,