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?