0 Replies Latest reply on Sep 26, 2018 1:18 PM by Eric Bettinger

    Trouble with averaging over time

    Eric Bettinger

      Hello everyone---just want to say that I'm so grateful for this community to bounce issues off of---has made a world of difference in working with Tableau!

       

      I'm running into an issue with the attached workbook. I'm looking at data over the last "X" months (usually 12) and trying to calculate a Year-to-Date average. What I'm coming up with is lower than when I'm doing the math manually. Any help is greatly appreciated---I had assistance in building this workbook and to be honest I'm not entirely sure how the calculation for YTD was built and why 'Round' in included and/or if there is a better way to get to my answer.

       

      Thanks in advance for the help!