1 Reply Latest reply: May 14, 2016 7:53 AM by Sunny Talwar RSS

    How to setup trend with Avg count per month

    youssef lachgar

      Hi Guys,

       

      I have a tricky question where i can't find a solution, below you can see a chart where i display some data (Helpdesk) :

       

      Capture.PNG

       

      On this chart :

       

      Dimension is  :
      =Request_MonthYear

       

      Mesure 1 Open ticket      :   

      Count({<ACCOUNT_ID={$(vCompany)},Request_Month={'*'},Request_Quarter=,Request_Year={'*'}>}distinct(sr_id))

       

      Mesure 2 Active ticket  (Backlog)   :

      count({<ACCOUNT_ID={'$(vCompany)'},status_class={'Open'},Request_Month=,Request_Quarter=,Request_Year=>}distinct(sr_id))

       

      Reference line (green)   :
      =Avg(Aggr(Count(Open_Tickets_Dayes),Request_MonthYear))

       

      As you can see everything is working well, what i am looking for is to have the reference line setup for the last 4 month only.
      So this line will be an objectif for the help desk team that will adapt every month compare to the last 4 month.

       

      The goal is to assign an objectif that is below the AVG number of ticket open the last 4 month

       

      Any idea ?