1 Reply Latest reply on Sep 24, 2014 2:18 AM by Radha Dorairajan

    Trailing Three Month Period

    Henry Martz

      I'm trying to organize volume data which I have on a daily basis.  We commonly analyze this data at the quarterly level for trends.  To account for months that dont fit into calendar quarters is there a way to make a trailing three month field?

       

      For example, if the data was  from January 2013 to August 2013 I would want Tableau to calculate Q1'13, Q2'13, and then the trailing three month period ended August 2013 (June + July + August) so that each period represents a three month period.

       

      First time posting, thanks for your help in advance!