6 Replies Latest reply on Nov 24, 2012 9:30 AM by Stephen Jones

    Calculation to count unique occurrences of text strings

    Stephen Jones

      I am looking for a way to 1) count the total unique occurrences of text values in a dimension, then divide a measure by that result.

       

      The attached file shows faculty members who taught classes in a given semester. I want to total the unique faculty (in this case the result would be 4 distinct faculty members), and then divide the total Student Credit Hours (323) by that number (4) to get the average Student Credit Hours per faculty member (which should be 80.75). How can I do this? 

       

      I'm a new Tableau user. Please forgive my lack of understanding. I've tried to read quite a bit, but have not been successful as of yet.

       

      Many thanks!

       

      Stephen