8 Replies Latest reply: Apr 27, 2014 12:06 AM by Sunil Chauhan RSS

    Rank an aggregated count

    Matthew Bowers

      Hi

       

      I'm sure this is pretty simple but I cannot seem to get my head around it

       

      I have a variable vCount:  aggr (count ({1}race_time),race_distance, temp, altitude)

       

      What I want to achieve is to take the race_time values that make up the aggregate and then rank them from lowest to highest. E.g:

       

      race_timerank
      9.854 / 4
      9.581 / 4
      9.753 / 4
      9.652 / 4

       

      Any help greatly appreciated.

       

      Thanks

       

      Matt