2 Replies Latest reply: Aug 27, 2012 9:06 AM by Ismael Villegas II RSS

    Calculate running average in table

    Ismael Villegas II

      QV Community,

       

      I was hoping that someone could provide me some assitance in calculating a running average in a pivot table or straight table when using a date as a dimension. I am assuming that I have to use set analysis but I am having some dificulty with finding the correct expression.

       

      Thank you,

      DateCount ? HELP ME ?
      8/1/2012190 190
      8/2/2012179 185
      8/3/2012187 185
      8/6/2012294 213
      8/7/2012263 223
      8/8/2012196 218
      8/9/2012176 212
      8/10/2012159 206
      8/13/2012318 218
      8/14/2012228 219
      8/15/2012187 216
      8/16/2012189 214
      8/17/2012121 207
      8/20/2012213 207
      8/21/2012103 200
      8/22/201263 192
      8/23/201252 183
      8/24/20123 173