In a repeating group, I’m looking to display the most recent record of Player 1, Player 2, Player 3 and Player 4 where the Court and Timeslot align with the x and y axis on the RG.
You can use the Calendar workflow logic and its DB structure but rename fields to yours
Go to the editor and run as admin from DB and look at the Time-tracker section (where X & Y table)
Play around with the Calendar, check how is made and use it for your case