I am trying to pass a database query result from one cell in a repeating group to the next, in order to create a cohort table.
I want to build a horizontal repeating group showing Active users and their registration date
Just for illustration here’s an image of what I have in mind:
Is there a way that I can, for each week, simply calculate the actives once and then reuse that list of players in the other cells of the column?
Or do I have to make a new query for each cell?
Also, if I have to go with option 2, will that make the page heavy and slow?