6 Replies Latest reply on Jul 20, 2018 9:31 AM by Vishrut Bali

    Display daily calculated ticket backlog

    Vishrut Bali

      I have a table with ticket id, created date, closed date and status fields. I need to display a count of opened and closed tickets on each day along with the total number of open tickets until that day(backlog). I am facing issues with displaying the backlog, I tried using the running_sum but that just adds up the values even when the closed count is more than the open count on a day which should actually lead to a decrease in the backlog count. The 1st table below is what I have and the second is what I need to display.

       

      TicketID
      Created DateClosed DateStatus
      107/14/201807/16/2018Closed
      207/14/2018Open
      307/15/201807/15/2018Closed
      407/16/2018Pending
      Date
      Opened TicketsClosed Tickets
      Backlog
      07/14/20182024
      07/15/20181124
      07/16/20181124
      07/17/2018

       

      Kindly let me know of any possible solutions to display above such calculations. I would prefer a solution that could be done without the need of any temporary date table etc.