Exporting data

It is possible to export data from some reports within Mosaiq Insights to comma-separated (.csv) files. This functionality is available whenever there is an “Export” button in the top right of the screen (1) between the “?” icon (for this Knowledge Base) and the “Share” button.

Filter selections made at the top of the screens (ie date range, operators, services, variant) will influence what data is included in an export (2), and the current sort order will be applied.

The files generated will be named as follows and downloaded to your browsers default download location:

<CustomerName>-<ScreenName>-<CurrentDate>.csv

Where the data displayed on screen in Mosaiq Insights for the chosen filter selection(s) is split across multiple pages, all pages will be included in the exported .csv file. In the

In the example screenshot above, “Export” will produce a file called:

oxleyshire-transit-services-20240611.csv

It will contain data for the month of May 2023 for “All Operators” and “All Services”. It will be sorted by Punctuality - descending, and contain 54 rows.

Export functionality is currently available on the following screens:

• Operators list view

• Services list view

• Service details view

• Journeys

• Running times

• Stop Details

The Export function on Journeys will not return any values for the following columns prior to 28th April 2024:

• journey_start_actual_time

• journey_end_actual_time

• journey_arrival_time

• journey_departure_time