RG Sorting - Similar values first

[vnihoul77]

Hey!
Is there a way to sort a RG like this :

• Date source: User’s likes
• Sort by: this item User’s likes is in Current User’likes

To have the values matching coming first…
Thanks

[ed727]

I’d also be interested in a solution to this. It’s also discussed in this thread with a manual workaround as an imperfect solution.

Best Intersect between 2 lists

Hello! I have several “accounts”. Each account has a “list of categories”. I want to select an account and get the other account for which the intersect of their “list of categories” returns the maximum count. However, I’m stuck. I am able to get a filter in place with the intersect count >0 but am not able to get the account whose list of categories has more in common with the current account. Can anyone help me out?

[vnihoul77]

@ed727 Thank you for answering.
I just check, unfortunately this solution would be not working with my current data organization…

[keith]

You can do mapped sorts like this using List Shifter’s SORT action.

Sorting according to a Thing's Thing field

List Sifter’s SORT action does this. Put List Shifter on page Set its “List to Shift” as the list you need to sort. Fire the SORT List Action at it. For “Source Sort List”, just compose the Thing’s Thing’s field. List Shifter’s “Shifted List” output now contains the sorted version of the list. Example: [image] Here’s an explorer page demonstrating this basic use of SORT in List Shifter: And here’s the editor.

The not possible sort repeating group by

Hey @casheets123, I made exactly the demo scenario you described. I’ve not made a video explaining this yet, but see my text on the page and examine the editor to get an understanding of how its done. While doing this, I realized that it was WAY harder (in this exact example) to figure out how to turn the list of Paints into a list of counts of those Paints than it should be. So, I did it the hard way first (that’s the link I share here) and then I updated List Shifter with a new function that …

List Shifter: Reverse, Rotate, Swap and ITERATE (Loop) Over Bubble Lists | Now at v1.4: Adds Numeric Option, GET INDEX Action

Hey @gavin1: Well, thank you for your support! So there’s a much faster way to do this (and sorry it’s taken me a while to respond). You’re correct that it involves the SORT action. What we would do is take a list of random values (52 if you have 52 cards in your deck, for example) and then SORT the deck by that list. List Shifter makes this super easy, and I’ve created a demo page for you: The editor is here. There are actually 2 “random” functions in List Shifter and I demonstrate usin…

[ed727]

Many thanks – will check it out.

[remi]

You can also do it by interstecting similar values in an hidden RG.
And then Showing the result of the hidden RG merged with the values you want to show.