Device data

Analysing your devices data

The 'Device - Data' page shows you an overview of the latest measurements that were sent by your devices in a tabular form, providing various sort and filter options to refine the selection of the devices data you want to analyse.

Note that the amount of devices you see in the 'Devices' and the 'Devices - Data' menu items might differ.

A device only shows up in the 'Devices - Data' page when:

• your device has recently sent data.

• your device is added to a flow, which has a decoder enabled.

• you are using one of the common Things Device Types, of which the payload is decoded into SenML JSON output.

Devices - Data table

Each row in the table represents a device, and each column represents a measurement.

Note that there are 4 default columns: Device Name, Device Type, Customer Name and Last message time.

The remaining columns are deduced from the actual measurements sent out by your devices. For example, the Battery Voltage column will only be visible when one of your devices has sent out a Battery Voltage measurement.

You can sort the table by clicking the column headers and you can add filters by hovering over the right side of the column header and selecting the three dots.

The small menu on the right called 'Columns' can be used to select/unselect columns.

Maximum of 10.000 rows in the table

The table is optimised for sorting and filtering performance. To maintain the best performance, you will only see a maximum of 10.000 rows, which you can browse using pagination.

Exporting to CSV

You can easily download the 'Devices - Data' result set by clicking the Download icon just below the Search icon.

This will generate CSV file, containing all devices in the current selection. The CSV file will contain the measurements accompanied with the timestamp of that specific measurement.

Important: the CSV file is not limited to 10.000 rows: all devices that match your filter criteria are included in the CSV file.

A note on timestamps

The default column 'Last message time' is the latest time that a measurement was received from your device.

Not every device message will include all measurements. As a result the measurement values you see in the table might originate from earlier measurements than the 'Last message time'.

The clock icon next to the value will alert you that this particular measurement was received in a previous message. In the CSV download you will see this earlier timestamp as well.