3 Replies Latest reply on Sep 29, 2016 10:18 AM by Stephen Rizzo

    Top 5 bottom 5 for scatter plot with nested categories

    Philip Gladwin

      Hello,
      I'm using Tableau 10.

       

      I would like to plot a scatter diagram which shows the top and bottom 3 (say) customers on the same chart.
      I've seen example of how to do this but the twist I have is that I have nested categories.

       

      My data has the following form:

       

      IDSegmentSales1Sales2
      1A10.8071630.880733
      2A10.6045480.158946
      3A10.1539680.830589
      4A10.2666470.512324
      5A10.6503780.788036
      6A10.486350.641804
      7A10.3077210.519302
      8A10.4481420.285462
      9A10.3118920.184048
      10A10.3733460.376454
      11A20.426070.898604
      12A20.9022660.944655
      13A20.4739970.978443


      ...

      30A30.1550490.80947

       

       

      In a single plot I would like to show the top 3 and bottom three customers in each Segment?
      The top and bottom is defined by the column SALES 1.


      Could anybody suggest how I might do that?

       

      The chart I am after will contain
      3 top and 3 bottom for Customer A1 as defined by top and bottom SALES 1 values.

      3 top and 3 bottom for A2
      and 3 top and 3 bottom for Segment A3.

       

      In all the plot will have 18 data points.

       

      Could anybody help?

       

      Phil,