How to create a custom Odometer Report ?

 Applies To

  • MyGeotab
  • Reports

Procedure 

  1. Export the IFTA report by navigating to Activity >IFTA Report
  2. In the vehicles section, select Select all, Click Apply changes, click View, select Advanced
  3. Click on the Excel icon to download the report
  4. Insert a Pivot Table with following fields: 
    • Rows: Device

    • Values: Exit Odometer

  5. Save that report and upload to the database, rename to Odometer Report.
  6. Set the Report ViewDashboard, or Email report tabs as needed. 
  7. Complete the settings of the report and Save.

Additional Notes

Also, check the following resources: