3 Replies Latest reply on Sep 17, 2018 12:01 PM by Matt Hladun

    Return Value Based on Ranking

    Matt Hladun

      This one has exceeded my Tableau abilities...


      I have a list of scores in different subjects. I've been asked to identify the score that is at the bottom of the top 80% of the scores for that subject.


      So, for example, let's say there were 50 scores in a subject. I need to rank them from highest to lowest, identify the top 80% of the scores (which, in this example would be 40 scores) and then return the value of the last score in that top 80% (which would be the score ranked #40).


      Can this be accomplished in Tableau? I'm able to get the number of scores that represent the 80% of a given list but haven't figured out a way to return the value of that last score in the 80% list.