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

    Aggregating Bounce Rates from Google Analytics




      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 ])



      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!