Interest Matching Algorithm: Sort repeating group by match score

Hello fellow bubblers!
I’m building a sort of dating platform where I want to display the other members to the Current User in a pile-like repeating group (without the tinder plugin, just a 1x1 repeating group). This repeating group contains all relevant information about the respective member, including their interests.

What I would like to do is to sort this pile of profiles by the amount of shared interests with the Current User (lets call that amount matching score). I can easily calculate this matching score with the intersect with + :count operators. However, I can’t seem to figure out how to sort the repeating group by this matching score. If I try to sort it by a dynamic field which is this intersect with + :count “formula”, bubble says the following:

Does anyone have an idea how I can achieve this?

I would highly appreciate help here.

This topic was automatically closed after 70 days. New replies are no longer allowed.