Rank using a query
Hi everyone, I have a list of records that I need to rank, first by the expected start date, then by the final date required, then by the build priority, and last using the record ID. One thing t...
Forum Discussion
Hi @Emma Finger
I like the suggestion from @Mark Shnier (Your Quickbase Coach). It may be cleaner than my solution below if you can get it to work.
Looking at the way you have it set up now....
Because the blank start dates won't be ranked in your first queries, I'd suggest setting up something like this where you first handle the scenarios where they are not blank, then create rankings for when they are blank (only start the ranking after the total that have start dates).
If(not isnull([Expected Start Date]),
Size(GetRecords($QZER))+Size(GetRecords($QONE))+Size(GetRecords($QTWO))+Size(GetRecords($QTHR)),
Size(GetRecords("{289.EX.'true'}AND{58.EX.'"&[Region]&"'}AND{45.EX.'"&[Data Center Name]&"'}AND{148.XEX.''}")) + Size(GetRecords($QONE))+Size(GetRecords($QTWO))+Size(GetRecords($QTHR)) )
Let me know if that does the trick.
-Sharon
------------------------------
Quick Base Junkie
Quick Base Junkie
https://quickbasejunkie.com
------------------------------
I like the suggestion from @Mark Shnier (Your Quickbase Coach). It may be cleaner than my solution below if you can get it to work.
Looking at the way you have it set up now....
Because the blank start dates won't be ranked in your first queries, I'd suggest setting up something like this where you first handle the scenarios where they are not blank, then create rankings for when they are blank (only start the ranking after the total that have start dates).
If(not isnull([Expected Start Date]),
Size(GetRecords($QZER))+Size(GetRecords($QONE))+Size(GetRecords($QTWO))+Size(GetRecords($QTHR)),
Size(GetRecords("{289.EX.'true'}AND{58.EX.'"&[Region]&"'}AND{45.EX.'"&[Data Center Name]&"'}AND{148.XEX.''}")) + Size(GetRecords($QONE))+Size(GetRecords($QTWO))+Size(GetRecords($QTHR)) )
Let me know if that does the trick.
-Sharon
------------------------------
Quick Base Junkie
Quick Base Junkie
https://quickbasejunkie.com
------------------------------
Thank you @Quick Base Junkie I did test the option you posted and it also works, but as you said, the solution from @Mark Shnier (Your Quickbase Coach) is cleaner and will probably be easier to maintain when I undoubtedly get asked to add more fields to the calculation.
------------------------------
Emma Finger
------------------------------
------------------------------
Emma Finger
------------------------------