Get the count of rows by date and booleans, check in system

[luminrabbit]

Im trying a bunch of different things from different posts to put something together and now I have the Count difference between the Booleans (First Game / Second Game) counted.

Now I believe I need to separate them by date somehow?

Im going to give this post a try now (just stumbled across it)

@kyleheney

What you need to do is create a template column of the two columns you need to “combine” to apply your rollup. Make a template of the user’s email (or other unique identifier) and the date (you may also want to “lock” in the date formatting by first creating a template column that stores the date as text first — this might not be necessary, but it’s still something I do in these cases).

Once you’ve got the template column (i.e. email@email.com April 1, 2021), create a multiple relation that check if the template matches itself. Then, create a rollup on this relation to get the sum of all the matches.