6 Replies Latest reply: Oct 24, 2013 8:25 AM by Arnaud Klr RSS

    Chart with a moving average

      Hey everyone,

       

      I woule like to create an chart that is showing the moving average of completness (in %) of my task, and i don't find the expression needed to use a moving average.

       

      For exemple of moving average in my source file, i have:

       

      Date# tasks completed / month# total tasks / month% CompletnessMoving average
      1/1/20134580%80%
      1/2/20133475%77,5%
      1/3/201361060%71,67%
      1/4/2013121580%73,75%
      1/5/201322100%79%

       

      In this way, i would like to have a line chart showing the moving average evolution by date.

       

      I don't know if it's clear, but it will be really nice if someone can help me on this tricky chart

       

      Best regards,

       

      Arnaud