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. 

       

      Metric
      Location ALocation BLocation C
      Customer Satisfaction123
      Timeliness231

       

      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.

       

      Thanks,