Atrius makes it easy to export your data in CSV format for external analysis.
👍 This article will help you:
Export interval and bill data for your points and bill points
Export metadata for your buildings, points, and bill points
Check the status of your in-process exports
There are five main places where you can export data:
Buildings
Points & Bills
Data Manager
Baselines
Cards
Exports
Buildings
Go to Buildings on the left side menu. Switch to the table view at the top right of the page. Select one or more buildings using the checkboxes on the left side of the table. Then, go to Actions > Export building details.
A modal window will appear. Provide a title for the exported file. Then, select the fields you wish to include. Select 'Export'.
Points & Bills
Export data
Go to Points or Bills on the left side menu. Select one or more points or bill points using the checkboxes on the left side of the table. Then, go to Actions > Export data.
A modal window will appear. Provide a title for the exported file. Then, select the Resolution, Metric, Start date, and End date. For points, also select Days of week. Select 'Export'.
You'll receive an email when your export is available, or go to Exports to check the status of your export.
📘 Exporting currencies
If exporting cost data for points, the currency of the assigned pricing schedules are used in the export.
If exporting cost data for bill points, there are two options: use display currency (which will allow the user to export multiple bills of different currencies) or select a single currency to be used for the entire export.
📘 Exporting data across multiple timezones
All data will be exported in the local timezone of the building for each selected point.
If you are exporting source or minute resolution data across multiple timezones, the points will be grouped by timezone into separate CSV files.
Export metadata
To export metadata for your points and bill points, go to Actions > Export point details or Export bill point details.
A modal window will appear. Provide a title for the exported file. Then, select the fields you wish to include. Select 'Export'.
Data Manager
Go to a point or bill point's Data Manager tab. Then, go to Actions > Export data.
A modal window will appear. Provide a title for the exported file. Then, select the Resolution, Metric, Start date, and End date. For points, also select Days of week. Select 'Export'.
You'll receive an email when your export is available, or go to Exports to check the status of your export.
Baselines
Go to a point or bill point's Baselines tab. Select the dropdown menu on the right side of the table for any baseline, then select 'View baseline data'. In the baseline's Data Manager tab, go to Actions > Export data.
A modal window will appear. Provide a title for the exported file. Then, select the Resolution, Start date, and End date. Select 'Export'.
Cards
Go to a dashboard, and select Actions > Download CSV. The downloaded ZIP file will consist of one CSV file per card.
To export the data from an individual card, click the drop-down arrow on the card, and select Download CSV.
Exports
Go to Apps on the left side menu, then select Exports. Select 'New Point Data Export' or 'New Bill Data Export'.
Provide a title for the exported file. Then, select the Points, Resolution, Metric, Start date, and End date. Select 'Export'.
You'll receive an email when your export is available, or go to Exports to check the status of your export.