Tables


Overview

The Tables Module is where you will find a customizable list of data points collected from any sensor within your network. This tool can be found under the Data tab. With this tool, you can filter the data viewed by selecting a time frame, metric/unit, and applying custom metric related filters. Multiple Table setups (otherwise known as "Profiles") can be created/saved for quick viewing of specific data sets in tabular formats.

This article will cover the following topics:

Using Tables

1. Navigate to the Data Module by clicking the Data icon on the left side of the screen.

2. Navigate to the Tables sub-module by clicking Tables

3. Once in the Tables sub-module the user must determine the Template which determines how the table will be formatted.

There are 4 types of templates...

Note: For the walkthrough below, we're going to use the "custom" template.

4. Once the template has been selected, the user must then select the sensors to be shown in the Tables module. Click the  button to select which sensors will be brought in.

5.  Once at least one sensor is selected, data will begin to populate. If multiple sensors are selected the user must specify what sensor they'd like to look at.

Note: Within the Tables sub-module only one sensor can be viewed at a time.

6. Next, the user must specify what date and time frame to reference. This is done using the date/time picker tool.

7. If multiple sensors of the same type are selected, clicking this button will ensure all sensors use the same time frame.

8. By default, one metric will populate as soon as a sensor is selected. More metrics can be selected by clicking the   button.

9. If a metric has already been added but needs to be changed, clicking the words of the metric will allow the user to change the metric type. Clicking the X button will delete that metric from the table.

10. Filters can also be applied to the data set to only show OR hide certain data.

Note: If a filter is applied and later needs to be deleted using the button will remove that filter.

11. Once all the settings have been made the user can push these settings across all LIKE sensors that have been added to this Table profile. This means that if a user creates specific settings they can click the button and all these settings will be applied to all like sensors (e.g. If a user sets up a piezometer, then all other piezometers that were selected from Step 4 will also receive the same settings but any non-piezometer sensors would not be affected).

12. Now that the Table profile has been built and all settings have been applied, users may want to export this data for storage or uploading to other data systems. This can be done using the  button which will export data into a CSV file. If using this method for downloading all sensors within the profile will be downloaded as separate CSVs and then zipped.

If using the  button, data for all sensors will be downloaded into one Excel file but each sensor will be on a separate sheet within the Excel file.

Note 1: If the "Include metadata in export" box is checked, the file will include all metadata information in the download file. Things like sensor name, start and end time frame. metric parameters in use, etc.

Note 2: When the user uses either export button, data for ALL the sensors that were selected in Step 4 will be downloaded, not just the data for the sensor currently displayed.

 

Other Tools

Deleting Data: Another significant tool of the Tables sub-module is the ability to efficiently delete large chunks of data. This tool comes in handy when a sensor collects incorrect readings (e.g. a piezometer not connected to a logger properly) and the data points need to be deleted.

To do this check the boxes next to the data points that need to be deleted. Once at least one data entry is selected the   button will appear. Clicking that button will delete the selected entries.

Note: This process will permanently delete the data points, it does not hide them, it DELETES them!

 

Sorting Data: Once the settings have been put in place users can click on the header of each column to sort the data in increasing or decreasing values relative to that column.

 

Load More Tool: During the initial setup of each Table profile only a few data entries will be visible. If more entries need to be visible clicking the   button will show more data points. If there is a significant amount of data entries then you may have to click this button several times to see all the data entries.