Hi there, I’m been enjoying using Coda lately although I’m still finding it challenging to create views or tables that list specific results.
I have a very simple example with a list of projects where each record is a date and time spent on the project. As you’ll see it’s possible to have multiple records for the same project on the same day. What I’d like is have table list the total time spent per date. This would allow me to record over time the overall amount spent on each unique date.
Here’s a small example of this.
Ideally the Time Spent by Date table would list 3 unique records in this case
1/31/2018 -> 8 4/30/2018 -> 4 5/17/2018 -> 6
How can I have the Time Spent by Date automatically track new dates when they are added to the main Log table and the total amount of time spent for that date?
Thanks in advance for your time.