6 Replies Latest reply on Dec 12, 2018 1:31 PM by Tracey Dong

    Is there a way to distribute the date to different months?

    Tracey Dong

      Hi all,

       

      We need to create a month over month view for the total number of tickets that were open at the month. If a ticket is currently open, then it should be distributed to each month since it's opened. If the ticket was resolved, it should only be distributed to the month since it's open to the month it's resolved. For example,

      RIT001 should be distributed from Sep to Nov 2018 (as today is in Nov 2018)

      RIT002 should be distributed from Sep to Oct 2018

      RIT 003 should only be in Oct 2018

      RIT004 should be distributed from Oct to Nov 2018

      ...

       

      Can anybody help me on this? twbx file is attached.

       

      Thank you!

      Tracey