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.


      Thx,
      A