You need to change the SQL to calculate it in this way. You will also need to be specific as to what a “week” is - which day it starts and which day it ends.
Not likely, and the performance for pulling even just 4 Reports can be slow. You could have a single Report, and use automation to load the report for the chosen employee via click of Automation Button, Entity Button, or Entity Grid. I have the Punch Editor and Payroll setups operating this way.
With more automation, similar to above.
Run SQL script in SSMS…
DELETE FROM [EntityStateLogs]
Install the Punch Editor setup. Part of this Tutorial:
That said, there does not appear to be a stand-alone Tutorial for the Punch Editor. Kendash has put the Timeclock and PunchEditor into a Configuration Task instead… and you may not like the way his Timeclock is set up, since it is quite a different flow. Proceed with caution. I will try to find some time to create a Punch Editor Tutorial.
No worries. But each of these should be taken 1 at a time, and you should make separate topics for them.