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

    Average Data Across Dimensional Filter

    Nicholas Nemirsky



      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


      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.