4 Replies Latest reply on Aug 29, 2018 1:58 PM by Joe Oppelt

    Storing Rank or Using in other calculation

    Scott Schmeling

      Does anyone know a quick and easy way to store a Rank function to be able to use it in a later formula?  I have 25 metrics that we are ranking each location by.  Then averaging out the ranks to find the overall ranking for the location among others. 


      Location ALocation BLocation C
      Customer Satisfaction123


      From there I need to get the overall ranking for each location- based on a point formula and calculation, which uses the current ranks.  Any suggestions on how to do this in Tableau without having to go back and assign rankings in the raw data.