Trip modes Reports

Hi

We are setting up GPS Tag & WiaTag customers with the ability to allow drivers to select trip modes.

We have successfully created the Custom Status in GPS Tag and added a Custom Sensor in the Unit setting on the Wialon platform - tested and works fine. Showing each mode correctly as and when changed.

We have since been trying to build a report that can show the following trip data for each status:

- Start/End of each trip location breakdown with Trip Mode column, by day/date driver/unit
- Total Mileage in tips in Mode A
- Total Mileage in tips in Mode B
- Total Mileage in tips in Mode C
- Day of week and date with summary breakdown for the defined period selected for reporting.

Would really welcome any guidance to assist us achieve this - tried many ways by trying to understand Custom reports manual with no success. Have added a mock image of what we are trying to achieve.

Thanks.