4 Replies Latest reply on Jul 4, 2013 4:23 AM by Manoj Sharma

    how can I rank top/bottom 5 across multiple measures?

    Peter Nelson

      I've been using Tableau for just about a year now and this one's got me stumped.  I've searched the forums and haven't been successful finding anything exactly like what I'm trying to do.  I am attempting to rank the bottom n measures based on an audit performed by a supervisor on multiple individuals.  The sheet would already be filtered by the specific individual who was audited, but the intention is to identify the 5 categories they in which they have scored lowest collectively across 18 categories as areas for improvement.  Each category is a different measure so the traditional top n methods don't seem to apply.

       

      I'm sure this is relatively easy to do and I'll be slapping my forehead (Homer Simpspon style) when somebody posts a solution but I greatly appreciate any help provided.