Hi community. I am working with @Laura Polson to help our field staff be able to track their schedules while out visiting stores for various reasons. We would like to find a way to show visibility based on hierarchy (district to regional to territory) for assigned stores.
For example - if I am a District Sales Manager that is assigned 10 stores, I would need to be able to see my own schedule and metrics. My Regional Sales Manager would also need to see my schedule and metrics, along with other District Managers that report in their assigned region.
I am trying to leverage a Dashboard that has shortcuts to open sheets and reports that filter to the "Current User". I have also done the mapping of who reports to who for which stores. I am getting stuck on trying to graphically represent on a dashboard either a calendar view or even a simple chart. Example chart idea is grouped by District Manager that has a column for each store # that counts the # of times visited in the designated period of time. Any help would be greatly appreciated! Happy to connect live for demonstration and brainstorming. @Laura Polson is UK based and I am Atlanta based so will need to keep time frames in mind.
