Table
The Table Section displays detailed sensor data in an organised and interactive format. This section provides users with tools to view, edit, and manage their data effectively.
Last updated
Was this helpful?
The Table Section displays detailed sensor data in an organised and interactive format. This section provides users with tools to view, edit, and manage their data effectively.
Last updated
Was this helpful?
Note: Not all users will have all of these tools available to their log-in. This will depend the access provided to your user profile. Discuss with your AlphaX administrator if you require access to additional features.
Data Visualization: The table presents sensor datapoints as rows that include Timestamp, Device Tag, Channel Description, Raw Value, Sensor Type, Unit, and Actions.
Interactive Data Management: Each row provides interactive action buttons for operations like delete, duplicate, or edit.
Customizable Display: Users can tailor the data display to their preferences, including filtering by date, analyzing through AI, and adjusting table settings.
Export Capabilities: A suite of export options is available for data handling outside the platform, including clipboard, CSV, Excel, PDF, and direct printing.
Maximize View: A maximize option allows users to expand the table view within the current window for an uncluttered and distraction-free display.
Anomaly Filtering: An option to filter out data anomalies as per the sensor type's defined range ensures only relevant data is focused on.
Show/Hide Channels: A checkbox to reveal hidden channels helps in including data from system-defined or user-selected hidden sensors.
Access the Data Table: Upon logging into the AlphaX Platform, navigate to the 'Table' section from the main menu.
Sensor Data Display: Sensor data is automatically populated in the table based on your sensor selection.
Edit and Manage Data:
Click the 'Duplicate' button to copy data to another time range
Click the "Edit" Gear button to edit the datapoint value.
Use the 'Delete' button to remove data entries. Note: Deletion is permanent.
Customization:
Select the 'Table Settings' gear icon to choose which columns to display.
Use the dropdown menus and checkboxes to filter data and show hidden channels.
Data Export: Click the export icon to download the data in the desired format.
Maximize View: Select the maximize icon to enlarge the table within the window.
Filter Anomalies: Activate the 'Filter Anomalies' button to exclude outlier data points based on the selected sensors range.
Warning: Before editing, deleting or copying any data, verify that it is the intended action, as these actions cannot be reversed.
Purpose: The sensor selection area allows users to easily identify and choose the specific sensor they wish to analyze or manage data for.
Location: The sensor selection area is prominently located at the top section of the Data Table interface within the AlphaX Cloud platform.
Functionality:
Single Sensor Selection: Click on the drop-down menu to reveal a list of available sensors. You can select a single sensor to view its data in the table below. The data displayed will automatically update to reflect the readings from the chosen sensor.
Search Functionality: If you have numerous sensors, you may use the search function within the dropdown menu to quickly locate a sensor by name or identifier. Start entering the sensor description or tag to trigger filtering the list dynamically as you type.
Sensor Information: Upon selection, the sensor's relevant information, such as the measurement type (e.g., TVOC - Total Volatile Organic Compounds), is displayed alongside the sensor selection. This provides immediate context for the data presented in the table below.
Instructions for Use:
Access the Table: Navigate to the 'Table' section within Analytics on the AlphaX Platform.
Open Sensor Selection: Click on the sensor selection box to view the list of sensors.
Choose a Sensor: Scroll through the list or type in the search bar to find your sensor. Click on your desired sensor to select it.
View Data: Once selected, the data table will refresh to display data for the selected sensor.
Sensor Details: Optionally, hover over or click on selected sensor details for more information or to confirm the sensor's settings and range.
Proceed with Data Analysis: With the sensor selected, you can now use other features of the AlphaX Cloud, such as exporting, editing, or analyzing the sensor data.
The "Explain It!" button in the AlphaX Platform is an advanced tool designed to perform automated data analysis. This feature provides insights into aggregated data, detects anomalies, analyses content, and presents findings in an intuitive and human readable format.
Data Grouping Preparation:
Before analysis, ensure your data is correctly grouped according to your preferences on the device manage page.
Initiate Analysis:
Locate and click the "Explain It!" button within the platform. This is found in the heading of the table itself and identified as a blue AI Microchip.
Anomaly Detection and Analysis:
The "Explain It!" feature will aggregate your data and run an anomaly detection algorithm across it, analysing the data's contents.
Review Analyzed Data:
Upon completion, the system will present the analysed data in a chart format. Accompanying the visual representation, a descriptive analysis will be provided.
Export or Email Analysis:
You have the option to export the analysis into a PDF report for offline review or sharing.
Alternatively, you can directly email the analysis to yourself or colleagues from the platform.
Interaction with the Analysis:
A set of interactive buttons will be provided with the analysis including make recommendations and make predictions based on the provided sets of data. Depending on the channel content, other interaction buttons may be available to dive deeper into specific data aspects.
Understanding Data Grouping: Ensure you are familiar with how your data is grouped, as this affects the analysis outcome.
Anomaly Detection Insights: Review the anomalies detected to understand potential issues or notable trends within your data.
Accuracy of Predictions: Be aware that predictions are based on existing data and may not account for unforeseen external factors.
Utilizing Recommendations: Apply the recommendations provided in the context of your operational knowledge and expertise.
Exploring Further Analysis: Engage with additional analysis options to gain more detailed insights where available.
Exporting data from the Table Section in AlphaX Platform allows users to take their sensor data and utilize it outside of the platform for additional analysis, reporting, or record-keeping.
Select the Sensor: Ensure that the correct sensor is selected in the sensor selection area and the data you wish to export is displayed in the table.
Adjust Data View (Optional):
Filter the data by date range, sensor type, or any anomalies if necessary.
Customize the table settings to display only the columns and rows you need.
Initiate Export:
Locate the export button, represented by the downward arrow icon positioned towards the top right of the table section.
Click on this button to reveal the list of export options.
Choose Export Format:
Select the format in which you would like to export the data. Options include:
Clipboard: Copies the current table data to your clipboard for pasting elsewhere.
CSV (Comma-Separated Values): A versatile text format that is compatible with most spreadsheet applications.
Excel: A format tailored for Microsoft Excel or compatible spreadsheet software.
PDF (Portable Document Format): A document format suitable for printing or distribution.
Print: Directly print the current table view.
Review Data Before Exporting: Double-check the data within the downloaded file to ensure accuracy and completeness after exporting.
Understand Export Formats: Choose the export format that best suits your subsequent use of the data.
Exporting Large Datasets: Be patient, as exporting large amounts of data might take some time.
Verify Exported Data: Once the data is exported, open it in the respective program (like Excel for .xlsx files) to confirm all desired data is present and correctly formatted.
Secure Handling: If the exported data contains sensitive information, ensure it is stored and handled according to your organization’s data protection policies.
Data duplication allows you to copy specific data points from one sensor channel to another within the AlphaX Platform. This feature is useful when replacing sensors or needing to replicate data sets for comparison or backup purposes.
Preparation:
Confirm that the data you wish to duplicate is correctly displayed in the table.
Ensure that both the source and destination channels are correctly set up in the platform.
Initiate Duplication:
Locate and click the 'Duplicate' button, found above the sensor selection sections or within a selected data row’s actions menu.
Select Destination Channel:
A dialogue will appear prompting you to select the channel where you want the data to be copied to. Choose the appropriate channel from the list provided.
Define Date Range:
Specify the date range of the data you intend to duplicate. This filters the data points to only those within the set timeframe.
Confirmation of Data Points:
The system will then inform you of the number of data points that will be duplicated. Review this to ensure it matches your expectations.
Save the Duplication:
To proceed with the duplication, click the 'Confirm' button. This will initiate the copying of data from the selected range to the chosen channel.
Data Verification: Before duplicating, verify both the source data and the destination channel to prevent any unintended duplication.
Irreversibility: Be aware that the duplication process is not reversible. Once data is copied, it cannot be undone through the platform.
Data Integrity: Ensure that duplicating data is in compliance with your data management policies and does not lead to data redundancy that could affect data integrity.
Post-Duplication Check: After duplication, it is advisable to check the destination channel to confirm that the data has been duplicated correctly and completely.
Warning: Duplicating data is permanent and can not be undone. Ensure that all settings are correct and correctly configured before committing to changes.
Bulk deletion is a feature within the AlphaX Platform designed to allow users to efficiently remove large quantities of data within a specified date range. This function is essential for managing data storage or clearing outdated or irrelevant data.
Data Review:
Before deletion, carefully review the data in the table to ensure you are deleting the correct entries. Verify the sensor and data range that will be affected.
Initiate Deletion:
Click the 'Delete' button, which you can find above the sensor selection window and to the right of the screen.
Select Date Range:
In the dialogue that appears, select the date range for the data you wish to delete. Only data within this range will be affected by the bulk deletion.
Confirm Deletion:
If you are certain about the data points to be deleted, click the 'Confirm' button to proceed. This will execute the bulk deletion of data for the specified date range.
Irreversibility: Understand that the deletion of data is permanent and cannot be undone. There is no way to retrieve data once it has been deleted from the platform.
Data Backup: Consider exporting and saving the data set to an external storage solution before performing bulk deletion if you might need the data in the future.
User Privileges: Ensure you have the necessary permissions to perform data deletions within the platform. Only users with appropriate privileges should execute bulk deletions.
Confirmation: Double-check the selected date range and the number of data points before confirming the deletion. This helps prevent accidental loss of valuable data.
Warning: Deleting data is permanent and can not be undone. Ensure that all settings are correct and correctly configured before committing to changes.