Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Open Ticket Count

Hi Everyone,   I have a below requirement and I am struggling to get this done and looking for some help. If anyone has any suggestions on how to acheive this, please let me know and that would be ...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Ryan,

     

    Thank you for your help, it is working fine for Jan month but from Feb it is not giving accurate numbers, it is giving what ever the open count left from JAN which are closed in feb for example if the Jan have 10 tickets and 2 got closed in Jan itself then Jan count is 8 this is working fine but from that 8 tickets if 2 were closed in Feb it is giving remaining 6 count for Feb it is not adding Feb opened ticket count.

     

    Thanks.

     

     

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      4 years ago

      Anonymous 

      i updated the sample data.

      like what you said, 10 tickets in Jan and 2 closed in Jan, then the result for jan is 8.

      2 tickets colsed in Feb and one open in Feb, the the result for Feb is 8-2+1=7