3 Replies Latest reply on Jan 16, 2014 10:26 AM by Andrew Ball

    Moving (rolling) average by date, not rows

    Lars von Sneidern

      Hello all, long time lurker, first time poster.

       

      I am trying to do something that I am not sure is possible in Tableau, and have not seen anyone else ask about much and.or solve.

       

      I have a large set respondent-level survey data I am working with. Each response has a specific date it is associated with, and each date has one or multiple responses (rows), or none in some cases (no responses collected those days. I want to do a moving average of the responses..easy right?  Not so fast!  I do NOT want the average based on the rows, rather moving based on the DATE.  I.e., I want Tableau to look at all responses for the current date and a defined number of DAYS behind it and average all the encompassed responses.

       

      Attached are two files:

       

      1. Excel file with a sample of the raw response data in one sheet, and another sheet with an example of what I am trying to accomplish.
      2. A Tableau file the the beformentioned data.

       

      Any help would be greatly appreciated!


      I would even be willing to pay for some consultation to solve this.

       

      Thanks all!