7 Replies Latest reply: May 31, 2016 4:26 PM by Jean-Christophe GUILLERMIN RSS

    Compute Rolling Average with multiple criteria

    Jean-Christophe GUILLERMIN

      Hello,

      I am trying to compute the production time per week per work center. Here is what the input file looks like:

       

         

      Work CenterWeekArticleProduction OrderReference Time
      A1totoO12
      B1titiO24
      A1tataO33
      C1titiO44
      A2totoO52
      A2titiO64
      B2tataO73
      C2titiO82
      C3totoO93
      C3totoO104
      A3titiO112
      B3tataO125
      B3titiO132

       

       

      As I have 100's of production center, I would like to display only the one where the production of the week (sum of the reference time of the week for each work center) is less than 10% of the moving average of the last 2 week of this same production center (i.e. a quick way to identify a production center is producing less than what it should be).

       

       

      I have build a table using group by agregating the data by week, but i am stuck there. Where should i start?

       

      Thank you for your help

      Rgs.