You can now generate a data export in an Excel format instead of CSV or PDF formats.
Excel reports have the ability to filter set up automatically within the report so you no longer need to set up the filter options manually.
We are going to demonstrate how to use these filtering options to get the information you need.
Step 1: Export your data from your iPhone, Android or the Web Dashboard. The report will be emailed to your account email address. Once you receive the email you will click on the green Download Trips XLSX button.
Step 2: Once your report has opened it should look similar to this. You will see all of your trips with each category having a drop down arrow that you can click on to filter (the red arrows point to where to locate this).
Step 3: In this example, we will show you how to filter your trips by Date (but you can do it by Purpose, Business, Place, etc). Click the on Date to bring up the dropdown menu.
Step 4: Click the Select All to remove the checkmark from all of your dates.
Step 5: You can now click on the Dates(s) you are wanting to view. Once you've highlighted the dates you need, press Okay.
Step 6: Once you’ve selected "Okay", the new view will show just the trips for the dates you have filtered:
Step 6:To remove the filter Date to return to the original report view, click the dropdown menu for Dates and select "Clear Filter from Date"
All Trips are now displayed like they were in the beginning!
As always if you have any questions, comments or concerns please send them to firstname.lastname@example.org