1 Reply Latest reply on Sep 14, 2013 5:22 AM by Paul Danese

    Aggregate points grouping by a measure

    Paul Danese

      Hi,

       

       

      I'm using Tableau Public 8.0

       

       

      I have a hierarchical data-set in an Excel document (sample attached)

       

      • I have a column for "Case #"
      • Each Case # can have multiple "Reports" that are grouped by the Case #
      • Each Report might list the age of one particular person.
      • So...a single Case # might list multiple people with different ages
      • I would like to use Tableau to plot each case based on the average age within a single case
      • However, when I place Case # in columns & Age in rows, Tableau plots each individual report as a separate point.

       

      My guess is that it's pretty easy to fix this, but I don't know how.

       

       

      Any suggestions?

       

       

      Thanks!