14 Replies Latest reply on Oct 12, 2016 10:17 AM by Nicholas Nemirsky

    Average Data Across Dimensional Filter

    Nicholas Nemirsky

      Hello,

       

      I have data set up like the below format that I cannot seem to get Tableau to average all together and show as one circle on a scatter plot.  Instead, it shows up as three distinct circles on the scatter plot.

       

        

      NameValueCalculated Dimension Filter
      A70Below 80
      A9895+
      A9080-95

       

      When I add the dimension filter to the worksheet as color, it separates each row of Name A as the value that was shown in each of the three rows.  What I want it to do is take the average across (70+98+90)/3 and then show that as the final filter.  In this case, the average would be 86 and I would only want it to show once in the 80-95 range.