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: Staf...
Forum Discussion
So you need to know for every location for X number of dates ahead if you have coverage, say for the next two weeks?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Correct
------------------------------
Quincy Adam
------------------------------
------------------------------
Quincy Adam
------------------------------
- I suggest that you make a summary field on the Locations record to total the # of hours where the date is equal to today.
Get that one working and duplicate it but change the filter to date equal tomorrow.
The duplicate that one and change the filer to
where
Date is during the next 3 days
Date is not during the next 2 days. (ie think Venn Diagram).
Then duplicate that for next 4 days but not during next 3 days .....
Just keep going as far out as you like.
If you want to get fancy after that all working there is a way to auto rename the field each night using Pipelines and API calls to reflect the actual dates and not a generic name like Total hours 3 days from now.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
