3 Replies Latest reply on Aug 13, 2013 5:39 PM by Patricia Schmuhl

    Creating average and binned data with count distinct

      I am new to Tableau but have a large survey dataset with multiple responses for survey questions. I have created an extract and am using the Count Distinct function to do my histograms and frequencies. However now I want to find the average age but of course the average age is based on the number of rows in the dataset and not the number of distinct rows. So how do I use count distinct function to created an average. I would also like to bin some of my measures in making a histogram but don't appear to be able to using count distinct. If someone could point me in the right direction would be a great help. Thanks.