I am trying to develop a ServiceDesk Plus KPI report that shows the number of open service requests per technician over time.  Note that this isn't "Number of Requests Opened" but rather "Number of Open Requests on a particular day"  The preferance would be a chart or graph that summarizes by week.

 For example:

 Open Requests by Week (As of Friday 1700)

  Technician

                  Week 1       Week 2      Week 3

       John      13                  32            15

      Kathy      12                  27            54

      Mark        16                  11            12

 

The intent is to figure out how efficient we are at keeping the open request queue under control.  The problem is, I can't figure out how to do snapshots of a particular date unless I start a new database and record values in it to collect data over time.  Suggestions?