Data export

Data can be exported from a dashboard to a CSV file in two ways. In addition, panel graphs can be exported to image files.

Exporting dashboard data to CSV

A dashboard shows multiple panels of data according to the selected filtering options. All displayed data can be downloaded as a CSV file using the Download as CSV button. To do so

  • set the desired period,
  • select the filtering options,
  • select the aggregate function if needed, and
  • adjust the aggregate interval if an aggregate function is used.

The below example selects hourly maximums values of battery and pressure sensor data collected from devices 255, 281, and 282 during the last day.

_images/dashboard-select.mov.0.gif

Once the desired data is selected, Download as CSVAggregated can be used to downloads the CSV file. This CSV file contains aggregated data corresponding to the panel graphs displayed on the current dashboard.

_images/dashboard-aggregated.mov.0.gif

The resulting CSV file contains entries like in following example:

Timestamp,Timezone Offset,255.battery,281.battery,282.battery,282.pressure
2017-02-08 11:00:00,+01:00,2.881,2.98974609375,3.00146484375,0.00199584960937
2017-02-08 12:00:00,+01:00,2.881,2.99267578125,3.00439453125,0.001904296875
2017-02-08 13:00:00,+01:00,2.881,2.99267578125,3.00439453125,0.00210571289062
2017-02-08 14:00:00,+01:00,2.881,2.99267578125,3.00146484375,0.00208740234375
2017-02-08
...

If, instead, raw data as received from the devices is desired, Download as CSVRaw should be used. The aggregate function is ignored in this case.

_images/dashboard-raw.mov.0.gif

The resulting CSV file contains entries like in following example:

Timestamp,Timezone Offset,255.battery,281.battery,282.battery,282.pressure
2017-02-08 11:44:53,+01:00,2.881,,,
2017-02-08 11:47:05,+01:00,,,3.00146484375,0.00199584960937
2017-02-08 11:57:04,+01:00,,,3.00146484375,0.00186767578125
2017-02-08 11:58:07,+01:00,,2.98974609375,,
...

Note that exporting raw data creates CSV files with sparse row entries. This happens because individual devices are not synchronized, and therefore neither the timestamps are.

Exporting panel data as CSV

Downloading CSV data from an individual panel is possible with Export CSV panel menu button. To download the data from a single panel:

  • set the desired period,
  • adjust the aggregate function (there is no option to download Raw data with this method),
  • adjust the aggregate interval,
  • click on the title of the panel,
  • click on the button with three horizontal lines,
  • select Export CSV menu item from the dropdown list to open or download the CSV content, and
  • if the CSV file is opened in the browser, use its Save command to download it.
_images/panel-download.mov.0.gif

Note

CSV output formats in these two approaches are slightly different. Also, you may need to set the delimiter to comma (dashboard data) or semicolon (panel data) when importing the CSV file into Microsoft Excel.

Exporting panel graph as image

A panel graph can be exported to an image file by selecting Share in the panel menu. Click on Direct link rendered image in the appearing popup and use the browser’s Save command to download it. The following screencast demonstrates how to export a graph to an image.

_images/graph-download.mov.0.gif