Count If This Week
Hello:
I am trying to create a view that shows whether staff are placed at each location each day of the week. It would be preferential to see the date vs. Mon, Tues, etc...
I have 3 tables: Staff, Location, Schedule. Staff is a list of employees. Locations are a list of locations. Schedule is where I assign Staff to a Location on a Date, with a Start Time and End Time. I also have a formula field to calculate Total # of Hours.
I have a table to table relationship between all tables, so I'm able to pull in a summary field from Schedule into Locations to see the Total # Hours, however, I need to see whether a location has coverage on each date. Total # Hours won't work since it will be cumulative. I'm not sure how to achieve this through summary field or report. All help is appreciated.
Thanks!
------------------------------
Quincy Adam
------------------------------