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 . . .

Export your Service History and Import it to Google Sheets
  • 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.

Create a Pivot Table

To do this go to Insert > Pivot Table.

Set Data Range to Service History
Go to your Data Range and make sure it is set to your Service History


Set Row to Tech

Go to your Rows and add Tech.

Add gallonage as a value
Set your value as gallons to see how many gallons each of your techs are working with.

Compare to chemical use
Now you can choose the chemical you would like to see the usage for per gallonage by setting that as another value. In this example, we're using tabs.

Add customers as a value
Now add customers as a value. In the "Summarize by" area choose COUNTUNIQUE. This will let you see the number of service stops per 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.