Forum Academy Marketplace Showcase Pricing Features

Matching fields with intersect and ranking

Hi there
I’m trying to add a ranking to my advanced intersect statement but I have no clue how to do it.

Usecase:
I compare the list values of two fields of each user in the user table. It works fine.
But the question is, how can I rank the search results (users) by the number of matches?
For instance:

CURRENT USER:
dictCanonDiagnoses: ValD1, ValD2, ValD3
dictCanonMedications: ValM1, ValM2, ValM3

USER A:
dictCanonDiagnoses: ValD3
dictCanonMedications: ValM1

USER B:
dictCanonDiagnoses: ValD2, ValD3
dictCanonMedications: ValM1, ValM2

USER B should be at the top of the list.

Thank you for your help!

Here is my statement:

Hey @marco.mueller,
i have the same problem, did you figure it out in the meantime?