Rank Using Query
I am trying to build a query that ranks the weights from high to low in a 1-X format. It is working, except when two records have the same weight it ranks them with the same number. Essentially, I wa...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendInteresting question and one that I don't recall being satisfactorily answered before.
Here is an example what worked for me to create an arbitrary tie breaker. I created a new field which was fid 8 called [Value + Record ID# /10000]
The formula as you might guess was
[Value] + [Record ID#] / 10000
Then I ranked that field using this formula
var text QUERY = "{8.LTE.'" & [Value + Record ID# /10000] & "'}";
Size(GetRecords($QUERY))
.
.
.
Note that there were triplicate and duplicate ties for Values 23 and 100 which were broken by the Record ID# / 10000
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
I looked at this problem as an exercise in code for me.
I went and sorted Rank as Mark has from 'Lowest to Highest' and it is the same as above. BUT, one of the things I get frequently are the spaces between data. which I don't want most of the time?
------------------------------
Bob T.
------------------------------- MarkShnier__You
Your table report is sorting and grouping by rank. Just change it so it sort by rank. The spaces are because you have chosen to have groups by rank.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------Thanks Mike. I see that when I sorted on the column Rank it was also grouping them. Customizing the sort to rank from low to high in the report settings worked.
------------------------------
Bob T.
------------------------------
