Repeating Group (Grouping) with aggregation of various fields

I have a table that contains records of emails and their current status by date.
I would like to create a repeating group that groups all the records by date and then allows me to show the user a count of total “scheduled”, “sent” & “rejected” per day.
Something that looks like this.

After reading quite a number of post on grouping repeating groups and nested repeating groups I still find myself stuck.
I have created the grouping within the RG (hopefully correctly) but can’t seem to be able to get the counts of status for each day.
What is the best way to build this?
Thank you.

This topic was automatically closed after 70 days. New replies are no longer allowed.