Count only values from today

Ask for Help
1

Table Name: THINGS

Columns: Name, Weight, Date

Interface: collection of THINGS. Filter collection to only see todays records.

Question: When the user is on this view to see all the things that they have collected today, how can I show them the total weight of all the things they collected today when they see this collection view filtered only for today. like in a simple text field. how is this done on the backend in tables?

2

image
image824×2163 254 KB

how accurate is this? going to try now but like to see the replies.

3

Not quite accurate. What I would do is create an IF column the checks if your date column is within Today, and if it is, then return the weight. Else, have it return 0. Then create a Rollup column that sums the weight from that IF column.

2 Likes