2 Replies Latest reply on Nov 10, 2016 5:14 AM by Steven Mullin

    Filter By Measure Names, Colour By Other Measures

    Steven Mullin

      Hey guys,

       

      I've got another problem that, hopefully, you guys in the Tableau community can help me out with.

       

      My data source has batch numbers in the first column.  Along the other columns I have counts at different areas for each batch.  I then have columns which calculate the 3 highest counted areas and a value for each of these 3.  Simplified version below -

       

      BatchArea AArea BArea CArea DArea EArea FMax2nd3rdMax Area2nd Area3rd Area
      00198501238065101239880CAD
      0021010050150986515010098DBE
      0036010100501238012310080ECF
      0046780101105012312311080FDB

       

      I have created a bar chart that shows just the top 3 areas with batch along X-axis.  In my attached workbook (Tableau 9.2) this is on Sheet 2.  What I'd like to do now is colour code each of the individual bars and the 3 sections by area.  As you can see, I've been able to colour them by category (max, 2nd, 3rd).

       

      On sheet1 I have been able to do what I need, but with only the Max value represented.  I'm struggling to bring the two ideas together.  Does anybody know if this is possible?

       

      Hopefully I've been clear enough.