1 Reply Latest reply on Aug 22, 2013 10:58 AM by .Yann Treguier

    Previous 3 mth avg ref line on a daily trending chart

    .Yann Treguier

      This is a continuation of another post that apparently is no longer active (http://community.tableau.com/thread/130011)

      I want to create a previous 3 mth avg reference line (just like the previous month avg ref line).  I don't think the LOOKUP can be used any more so I was trying the WINDOW_AVG(SUM(Sales),-3,0) but I can't figure out how to make it compute along the months instead of the days. Thanks

       

      Message was edited by: .Yann Treguier