1 Reply Latest reply on Sep 18, 2013 6:59 PM by Jonathan Drummey

    Moving Average based on Dates, not values/data points

    Anuja S Krishnan

      I want to calculate moving average such that I average values for last 30 dates and not last 30 data points.

       

      1) The data I have shows dates and values such that there are duplicate dates i.e. a given date could have multiple values. I want to calculate the average at each date such that while taking into account a 30 day period, I want these duplicate dates to be included. I do not want to aggregate my measure.

       

      2) Also, there are nulls/blanks i.e. not all dates have a value.

       

      Can this be done in Tableau? I am attaching a .twbx with sample data here.

       

      Any help is greatly appreciated.

      Thanks

      Anu