Where in your environment are you trying to display this? Is it a report within the same table? Or do you have a table set up to track each week for people? From how I'm interpreting your ask - my thinking is that you will need to set up a secondary table that will represent a unique point in time for each person. So you table would be something like 'People Weeks' that represent a unique week with a clearly defined start and end day (Sunday-Saturday for example) for each person - so you can store their % utilization week over week and be able to report for that time frame.
Chayce Duncan | Technical Lead
(720) 739-1406 |
chayceduncan@quandarycg.com Quandary Knowledge Base
