7 Replies Latest reply: Dec 8, 2011 11:10 AM by Stefan Wühl RSS

    Ideas/Advice on calculating a daily open case backlog.

      I have 150000 helpdesk tickets with open/close dates going back 4 years. What I am looking for are some ideas/advice on how to generate what the daily open case backlog has been.

       

      I can sort of do this with Excel (creating a matrix of date/ticket number and adding up left open tickets by the day) but rapidly bump into the 2 million cell limit.

       

      Thoughts appreciated.

       

      David Rowe