4 Replies Latest reply on Aug 8, 2016 8:29 AM by Shinichiro Murakami

    Average Equals "1"?

    Adam Rauh

      Hi All,

      Very new to Tableau.  I was playing with some data and am trying to calculate an average.  When I use SUM(Number of Records), everything seems to come up fine:




      But when I change the measure to 'AVG(Number of Records)', it goes to "1" across the board:


      Wonder what I am missing here...


      Any help would be greatly appreciated.