Group By in Repeating Group

theonlyefua · 2024-12-25T23:21:25.037Z

I have a repeating group to display a list of Operating Expenses grouped by categories and aggregated by amount as shown

How can I tweak the aggregates to have specific dynamic date ranges and always update to the last three months?

image1564×576 16.4 KB

mitchbaylis · 2024-12-25T23:50:46.414Z

you’d have to do a search for each aggregate within the table

it’s not ideal since you’re doing searches within a repeating group - but since there are a limited number of rows and you need the results to be changeable by the user (dynamic date ranges) you’d have to do searches for each rows aggregate

If you intend on showing 12 months you may be best to run the searches in a backend workflow (offload it to the server) and then store the numbers in a data type that can be accessed and loaded frequently by the user - if it is something that is fairly static and needs to be viewed often.

but for 3 months and 3 rows a search for each of the 9 results would be fine as well. aggregate searches are actually very cheap in terms of WU units in bubble since they only return a number

theonlyefua · 2024-12-28T22:58:53.218Z

I’ll try this out. Thank you, Mitch

theonlyefua · 2025-01-08T17:54:46.290Z

This worked for the table. Though I didn’t use a backend workflow

I guess I don’t need the Advanced filter for the Totals row

Screenshot 2025-01-08 1753111791×713 106 KB