13 Replies Latest reply: Apr 20, 2017 6:25 PM by Monica Labrador RSS

    Count of number of open tickets a month

    Monica Labrador

      Hi, I am trying to build an app which counts the number of open tickets in a month. I am having trouble thinking through how to calculate cumulative remaining tickets opened. Any help or direction is appreciated.

      The chart would summarize like below:

      Month, number of open tickets:

      Jan-2017 4

      Feb-2017 5

      Mar-2017 5

          

      case_numberdate_openeddate_closed
      11/2/171/5/17
      21/7/171/30/17
      31/8/173/1/17
      41/10/17-
      52/2/172/8/17
      62/5/172/20/17
      72/8/173/5/17
      83/1/173/6/17
      93/3/17-