I am trying to create a solution for a colleague, which based on the availability and integration of Workforce, seems like a simple task; however it's proving somewhat elusive. I've been asked to set up Workforce for our Volunteer Coordinator to track volunteers' availability, location and hours worked. One of the primary requirements is to produce at least a view of hours worked for each volunteer.
I'm not sure that a dashboard is the best way to do this. I have been trying to beat a dashboard (v2) into submission; using a list display filtered for assignments in the last month (for now, would ideally prefer to set a date range) and then trying to write some Arcade that would at least provide a readout of each volunteer and their hours worked.
The complications seem to be:
Other things I've considered
What would be your solution for understanding/displaying cumulative hours per worker across some time period?