I apologize - I am a noob when it comes to Coda and formulas. I am hoping to get some insight.
We have a People table that is staff and contractors in our business. We also have an events table that we assign these people to. An event has a travel in date (first day we travel to it) then the event start and end dates, and then lastly the travel out. So ultimately it might be something like:
Travel In - May 1st
Event Start - May 2nd
Event End - May 6th
Travel Out - May 7th
May 1st - 7th.
Photo example: https://share.getcloudapp.com/OAub2Lpk
I am trying to create a bar graph that basically shows all our employees and contractors and figures out how many days they worked, based on how I associate them with the event; so this person would have a date range between May 1st to 7th, and I want to calculate that they were ‘working’ 7 days, in a bar graph: https://share.getcloudapp.com/nOu81Ngd
Where would I even start?