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