3 Replies Latest reply on Feb 25, 2016 8:20 PM by Shinichiro Murakami

    Create a rolling average Calculated field.

    Harnish Patel

      I currently have my data set up by month for 2014 and 2015. I have graphed 2015 using bars and I want to graph 2014 using two properties. I want a horizontal line representing the total at the end of 2014 (December) and would like that total to be calculated as the sum of the 12 months (numerators) divided by the sum of the 12 months (denominators). Essentially a rolling average every month ending in December.

       

      Is this possible with tableau? currently What I've done is created a table manually in excel and just joined it in to get that line.

       

      screen1.png

       

      Thank you!

       

      -Harnish