Hi @Jeff-2aca no worries, thanks for clarifying . With what you have set up, creating a list view in app builder will only show the value of the filter in the ‘Pairings_Players’ column. For your example with Jeff it will display 7. If you decide to take the ROWS() path, you will end up with the same issue that we saw in my example earlier in the thread where it also shows rows 0.
To be able to sum the number of times a given player has played with other players, you will still want to set that up in a table. With the information you provided, here is what I would suggest. Create a player match table where column 1 is row linked to your ‘Player’ table and column 2 is also row linked to your ‘Player’ table. Example screenshot:
From there, I will mirror a similar set up from your ‘Player’ table with the ‘Parings’ and ‘Pairings_Players’ column. Note: there are slight changes to the formula
Screenshot of my ‘Pairings’ formula:
Screenshot of my ‘Pairings_Players’ formula:
My ‘Pairings_Players’ column now provides me the information I need. It tells me how many times player Jeff has been paired with player Mark, player Andy, player Baxter, etc.
Now that tables are set I can go into app builder and create a list that displays a list of all players Jeff has played with and how many times:
Screenshot of the app:
Hope this helps, happy holidays!