How to Decipher Your Data on Technicians
Curious how much of a chemical your technicians are using? Curious in general to see patterns in your technicians' work? If so we've got a solution for you. We'll show you how to take your Service History into Google Sheets to spot trends in your technicians' work.
To learn how to decipher your technicians' data, see the video below. Or, if you prefer, scroll past the video to view our step-by-step text instructions.
Step-by-step instructions . . .
- Navigate to Settings > Exports in Skimmer's web app. Choose the range of dates you want to use and click Export to Excel to save.
- Now take that file and open it in Google Sheets File > Import > Upload.
To do this go to Insert > Pivot Table.
Set Row to Tech
Go to your Rows and add Tech.
Now you are able to track chemical usage by technician and their number of service stops. This can be handy when trying to spot trends in chemical usage by your technicians.