2 Replies Latest reply on Dec 3, 2018 3:41 PM by none given

    Top N Filter not working correctly

    none given

      I normally use sort and index to get the top N records, but I can't in this case due to some design requirements.

       

      I've tried using the pre-set "Top by Field" in the filter, but it does not take the other view filters into account.

       

      My desire is to get the top 2 transportation methods by their countd(ID).  Using index it is correct, both CAR and TRAIN have 5 records.  When I use the "Top by Field" it incorrectly gives me TRAIN and WALKING (5,4 respectively).

       

      Thanks!