Hi guys,
I have a list of things which contains dates and a number.
Now I want to create a report site which sums this number per year and month. E.g. like the following:
2025 November 256€
2025 December 890€
2026 January 423€
2026 February 812€
and so on.
How can I achieve this best that it stays flexible? I mean that the table automatically expands to all consisting dates in that list of things and automatically sums the number for each year/month correctly?
Use a Repeating Group with the :group by operator on your data source. You’ll group your data by the date field (set the granularity to ‘month’) and add a ‘Sum’ aggregation for your number field. This creates a dynamic list where each row represents a month and shows the calculated total.
The simplest way is to use a repeating group whose data source is your list grouped by year and month (using :grouped by on the date field). Then display the year/month from the grouped date and use sum on the number field for each group.
This stays flexible because Bubble will automatically create new rows as new dates are added, without any manual updates.
Great that is really easy, nice!
