You usually monitor device performance, status, history, and interact with devices to increase optimum performance, but what if you could also view the device history as a table or line chart and export it as a CSV file instead? With the data exported in a table view, you can further dive into the data and share it with external parties.
You can get to the device details in a few ways:
Via the Site Homepage > Devices > search and select the desired Device from the device list.
When you search for a device by name and select it, you will be taken directly to its Device Details page.
The search function can be accessed by clicking on the search icon in the main navigation bar on the left.
Via the Site Dashboard > Areas > Select a Floor > from the floor plan graphic Click on Device Name (the same can also be achieved via system graphic)
To access the Table View, click on the Table Viewicon at the bottom of the right sidebar
You can also customize the Table View:
To view data from a specific date, select it at the top of the device details view.
Each column represents a point and you can add/remove by toggling the chart button on/off.
Each row is a timestamp representing point values.
You can adjust the column width by dragging the boundary on the right side of the column heading.
You can sort the table by date and time (Oldest/Newest), point values (high/low) or alphabetically.
You can export data from Device Details in a CSV format. You can export the data in a few ways depending on how you plan to use it.
Click on Export button at the top of device details page (Table or Dashboard View).
At “Choose Points to Export” page select:
The points you want to export from that device
The date range
The alignment period:
Raw Data
15 minutes
30 minutes
1 hour
Using these aggregate functions:
Average
Sum
Min
Max
On the exported file the data has the following structure:
Device ID and Name
Time
Selected points are individual columns
One column for point Value, one for point Status
The name of the exported file has the following format:
{SiteName}-{DeviceName}-{AlignmentPeriod}-{StartDate}-{EndDate}
Start and End Date are the dates selected for the export.