https://community.esri.com/t5/arcgis-online-questions/create-time-worked-calculations-from-workforce-for/m-p/1089944#M41778 <P>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.&nbsp; I've been asked to set up Workforce for our Volunteer Coordinator to track volunteers' availability, location and hours worked.&nbsp; &nbsp;One of the primary requirements is to produce at least a view of hours worked for each volunteer.&nbsp;&nbsp;</P><P>I'm not sure that a dashboard is the best way to do this.&nbsp; 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.&nbsp; &nbsp;</P><P>The complications seem to be:&nbsp;</P><UL><LI>The time stamps are stored in the Assignments table, and related back to the Workers, not directly available in the Assignments table.&nbsp; The result ideally would be a displayed table/grid of workers and their hours worked for some given time period/range.&nbsp; The existence of only $datapoint globals in the Arcade editor for Dashboard modules suggests that maybe other tables aren't available to Arcade here?</LI><LI>Getting the expression to read all of the features in multiple columns (Can't figure out which modules Feature Sets are actually available in)</LI><LI>Constructing a strategy to arrive at the desired result</LI></UL><P>Other things I've considered</P><UL><LI>Creating fields using Arcade calculations that would store the calculation of hours worked for whatever time period, however this kind of dynamic solution wouldn't allow historical data to be retrieved / calculated.&nbsp;&nbsp;</LI><LI>Creating a new table to hold workers, their assignments and time worked... inserting a record upon assignment completion.&nbsp; Just thought of this, haven't looked into its feasibility.&nbsp; Not sure how this would work if an assignment is re-opened or edited unless more advanced functions are implemented.&nbsp;</LI><LI>I have accepted filtering assignments by date completed (say, "Last Month") as a way to define the time period.&nbsp; Setting the date range manually would be more flexible, or the option to do either would be even better; but the predefined date filters will probably be OK for now.</LI></UL><P>What would be your solution for understanding/displaying cumulative hours per worker across some time period?</P> Wed, 18 Aug 2021 17:05:32 GMT KennethLohr 2021-08-18T17:05:32Z https://community.esri.com/t5/arcgis-online-questions/create-time-worked-calculations-from-workforce-for/m-p/1089944#M41778 <P>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.&nbsp; I've been asked to set up Workforce for our Volunteer Coordinator to track volunteers' availability, location and hours worked.&nbsp; &nbsp;One of the primary requirements is to produce at least a view of hours worked for each volunteer.&nbsp;&nbsp;</P><P>I'm not sure that a dashboard is the best way to do this.&nbsp; 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.&nbsp; &nbsp;</P><P>The complications seem to be:&nbsp;</P><UL><LI>The time stamps are stored in the Assignments table, and related back to the Workers, not directly available in the Assignments table.&nbsp; The result ideally would be a displayed table/grid of workers and their hours worked for some given time period/range.&nbsp; The existence of only $datapoint globals in the Arcade editor for Dashboard modules suggests that maybe other tables aren't available to Arcade here?</LI><LI>Getting the expression to read all of the features in multiple columns (Can't figure out which modules Feature Sets are actually available in)</LI><LI>Constructing a strategy to arrive at the desired result</LI></UL><P>Other things I've considered</P><UL><LI>Creating fields using Arcade calculations that would store the calculation of hours worked for whatever time period, however this kind of dynamic solution wouldn't allow historical data to be retrieved / calculated.&nbsp;&nbsp;</LI><LI>Creating a new table to hold workers, their assignments and time worked... inserting a record upon assignment completion.&nbsp; Just thought of this, haven't looked into its feasibility.&nbsp; Not sure how this would work if an assignment is re-opened or edited unless more advanced functions are implemented.&nbsp;</LI><LI>I have accepted filtering assignments by date completed (say, "Last Month") as a way to define the time period.&nbsp; Setting the date range manually would be more flexible, or the option to do either would be even better; but the predefined date filters will probably be OK for now.</LI></UL><P>What would be your solution for understanding/displaying cumulative hours per worker across some time period?</P> Wed, 18 Aug 2021 17:05:32 GMT https://community.esri.com/t5/arcgis-online-questions/create-time-worked-calculations-from-workforce-for/m-p/1089944#M41778 KennethLohr 2021-08-18T17:05:32Z