https://community.esri.com/t5/arcgis-dashboards-questions/using-dashboards-to-monitor-workforce-projects/m-p/1107735#M5243 <P>We have recently undertaken a project to verify the locations of nearly 27 000 ambiguous or multi-unit address locations on our registered voter rolls. We are using Workforce to dispatch crews out to each of these locations, and Field Apps to collect the correct address &amp; unit information at each of these sites.</P><P>The project coordinators have requested a high-level dashboard that shows how many locations have been inspected by each crew, the number of locations of each type currently assigned to each crew, etc.</P><P>This seemed simple enough, until I realized that in the new Workforce, the worker id and assignment type fields are both GUIDs, and Dashboards don’t support using GUID fields in charts!!</P><P>How much work has been done and what types of work are basic metrics that I imagine most Workforce organizers will need to visualize at some point.</P><P>Yes, I can write a script to translate these GUID values to strings and yes I can use Windows Task Scheduler to run it every 5 mins for the next year so that the project managers feel like they are getting ‘live’ updates, but this seems like a major hassle just to get 2 core pieces of Esri technology to talk to one another.</P><P>Are there any plans to make Dashboards and Workforce projects play nicely with one another?</P> Thu, 14 Oct 2021 22:33:47 GMT AllisonMuise2 2021-10-14T22:33:47Z https://community.esri.com/t5/arcgis-dashboards-questions/using-dashboards-to-monitor-workforce-projects/m-p/1107735#M5243 <P>We have recently undertaken a project to verify the locations of nearly 27 000 ambiguous or multi-unit address locations on our registered voter rolls. We are using Workforce to dispatch crews out to each of these locations, and Field Apps to collect the correct address &amp; unit information at each of these sites.</P><P>The project coordinators have requested a high-level dashboard that shows how many locations have been inspected by each crew, the number of locations of each type currently assigned to each crew, etc.</P><P>This seemed simple enough, until I realized that in the new Workforce, the worker id and assignment type fields are both GUIDs, and Dashboards don’t support using GUID fields in charts!!</P><P>How much work has been done and what types of work are basic metrics that I imagine most Workforce organizers will need to visualize at some point.</P><P>Yes, I can write a script to translate these GUID values to strings and yes I can use Windows Task Scheduler to run it every 5 mins for the next year so that the project managers feel like they are getting ‘live’ updates, but this seems like a major hassle just to get 2 core pieces of Esri technology to talk to one another.</P><P>Are there any plans to make Dashboards and Workforce projects play nicely with one another?</P> Thu, 14 Oct 2021 22:33:47 GMT https://community.esri.com/t5/arcgis-dashboards-questions/using-dashboards-to-monitor-workforce-projects/m-p/1107735#M5243 AllisonMuise2 2021-10-14T22:33:47Z