6 Replies Latest reply: Feb 12, 2018 11:51 AM by Sunny Talwar RSS

    How can I forecast for next three months using the below data?

    Niteen kumar
      Ticket Closed Year MonthTicket Count
      2016-jun.16977
      2016-jul.16126
      2016-aug.17413
      2016-sep.16923
      2016-okt.17425
      2016-nov.18854
      2016-dec.17007
      2017-jan.17647
      2017-feb.16861
      2017-mrt.20982
      2017-apr.16430
      2017-mei18587
      2017-jun.16291
      2017-jul.15215
      2017-aug.15911
      2017-sep.14385
      2017-okt.15532
      2017-nov??
      2017-dec??
      2018-jan??

       

      Can somebody pls help me?

       

      I used the formula: rangeavg(above(COUNT([Incident ID]),0,3)) to calculate the three month running average but the calculation stops at the month of october.

       

      I also tried : linest_m(total aggr(if(Count([Incident ID]),Count([Incident ID])),[INC Closed Time.autoCalendar.YearMonth]),[INC Closed Time.autoCalendar.YearMonth])*only({1}[INC Closed Time.autoCalendar.YearMonth])+linest_b(total aggr(if(Count([Incident ID]),Count([Incident ID])),[INC Closed Time.autoCalendar.YearMonth]),[INC Closed Time.autoCalendar.YearMonth]) to calculate the predicted value for Nov/Dec/January but was an obviate attempt.

       

      Looking forward to hear from the community.

       

      Message was edited by: Niteen Kumar Hi Sunny, i have added the qvf file also. Looking forward for interesting solution. Cheers Nitin