5 Replies Latest reply: Feb 29, 2012 4:52 AM by Janus Stensig Skov RSS

    Calculate "Rolling average" in script

    Janus Stensig Skov


      I´m doing some investigation on our Purchase-transactiondata and need to calculate a 3 month Rolling average per ProductID to identify "bad data" / outliers.

      The reason for trying to do it in the load script, is 1) that I have millions of records and 2) hoping to do some automation in the process of handling the "bad data" / outliers.

      I know that I can do something similar in Chart expressions, but finding it very hard to identify and handle "bad data" / outliers using Charts = a lot of manual work

      Any ideas out there?