Hello, I am trying to build an app that calculates multiple health data points such as total calories. For example, I have 3 submissions in the database for calories on 12/24/2021. I would like to be able to use the date picker to pick a date and then have a dynamic text function to show the summed total for the 3 calorie submissions and when a new date is chosen it will show the summed total for all calorie submissions for that date.
Any ideas on how to format the dynamic data to do this? I tried using the group and aggregation function but it didn’t work the way I tried to set it up.