For something as complicated as this, I’m going to be honest, I would use something a little more drastic because querying all the posts and then looping through every repeater of every post is going to be a time suck and impact the performance of your site.
I have an idea for a better approach that does not include doing any queries on posts or looping of repeater fields, but it depends on what you’re looking to keep track of.
Give me more details about the repeater and sub fields that you want to track and what you want to display on the home page and I’ll give you an example using that information.
