Sum of field in documents collection

Hi, I am very new to Flutterflow and need help I tried looking at other examples but can not figure this out. I know this is very easy but I have no programming background.

I have a collection "donations" that has a list of donations made this donation document store the "amount" and "charity" (charity is a ref to another collection) I would like to get the sum of the amount donated to a certain charity for a specific period(e.g last 30days or for august 2023) .

I would really appreciate it if someone could help me or point me in the right direction

6 replies