9 Replies Latest reply on Jun 21, 2018 4:12 AM by Mavis Liu

    Aggregating Bounce Rates from Google Analytics

    jonathan.turotn

      Hey!

       

      I am having difficulty stopping Tableau from averaging out my data from Google Analytics. I want to be able to show the BR % of a landing page for Today but it looks like Tableau is averaging out all dates up to the dates.

       

      Current calculation is:

       

      IF [Date] <= TODAY()

      THEN ([BR ])

      END

       

      I have tried making everything an aggregate by adding AVG before the IF as well as trying Fixed AVG.

       

      Any help or tips on where to look would be brilliant!