Real-Time Calculations

Subscription access level

This section describes all operations that a Subscription access level user can perform with Calculations (Real-Time).

What are Real-Time Calculations in Facts?

Real-time calculations in Facts are essential for dynamic data processing, enabling immediate analysis and response to data as it is received from connected devices. This feature ensures that organizations can make timely decisions based on the most current information, enhancing operational efficiency and agility. Real-time calculations can handle a variety of data inputs and perform operations ranging from simple transformations to complex computations using familiar Excel formulas. The platform supports the creation, editing, testing, and deletion of these calculations, with flexible triggering options such as time-based Cron expressions or event-based triggers. Additionally, significant data changes can automatically trigger outbound events, ensuring prompt notifications and actions. This powerful functionality is crucial for applications like industrial automation, energy management, and smart infrastructure, where real-time insights are vital for maintaining efficiency and proactive system management.

What can we do with Real-Time Calculations in Facts?

• Create Real-Time Calculations: This includes setting up new real-time calculations, modifying existing ones, and removing outdated calculations. These calculations can range from simple data processing to complex operations based on specific formulas and schedules.

• Create Events: When creating a real-time calculation, you can choose whether you want it to trigger an event or not. Click here to know more about Events.

Procedures

Create a Real-Time Calculation

1. Navigate to the Calculations section.
2. Click on the Real-Time tab.
3. Click the "+" symbol to add a new real-time calculation.
4. Provide a name for the calculation in the Name field.
5. Enter a description in the Description field.
6. Choose Real-time as the triggering type from the Triggering Type dropdown menu.
7. (Optional) Check the Outbound Events box if this calculation should produce an event.
8. Select Twins from the dropdown menu.
9. Select the required Inbound and Outbound capabilities from the respective dropdown menus.
10. Download the provided Excel template and apply the relevant calculations using standard Excel formulas tailored to your requirements.
11. Upload the completed Excel file back to the platform.
12. (Optional) Click on Test to test your calculation.
13. Click Create to finalize the setup.

Create a Time-Triggered Calculation

1. Navigate to the Calculations section.
2. Click on the Real-Time tab.
3. Click the "+" symbol to add a new real-time calculation.
4. Provide a name for the calculation in the Name field.
5. Enter a description in the Description field.
6. Choose Time-Triggered as the triggering type from the Triggering Type dropdown menu.
7. Define the schedule using the Cron Expression field or the Cron Expression Editor.
8. (Optional) Check the Outbound Events box if this calculation should produce an event.
9. Select Twins from the dropdown menu.
10. Select the required Inbound and Outbound capabilities from the respective dropdown menus.
11. Download the provided Excel template and apply the relevant calculations using standard Excel formulas tailored to your requirements.
12. Upload the completed Excel file back to the platform.
13. (Optional) Click on Test to test your calculation.
14. Click Create to finalize the setup.

Test a Calculation

1. Navigate to the Calculations section.
2. Click on the Real-Time tab.
3. Select the calculation you want to test.
4. Click the three dots "(...)" and select Edit.
5. Click on the Test.
6. Provide the necessary input data in the Input Data field.
7. Click Test to run the calculation and verify the accuracy and functionality of your real-time data processing.

Update a Real-Time Calculation

1. Navigate to the Calculations section.
2. Click on the Real-Time tab.
3. Select the calculation you want to update.
4. Click the three dots "(...)" and select Edit Calculation.
5. Modify the necessary details, such as the name, description, devices, triggering type, capabilities, and Excel file with rules.
6. Click Update to save your changes.

Delete a Real-Time Calculation

1. Navigate to the Calculations section.
2. Click on the Real-Time tab.
3. Select the calculation you want to delete.
4. Click the three dots "(...)" and select Delete Calculation.
5. Confirm deletion by clicking YES.

Archive a Real-Time Calculation

1. Navigate to the Calculations section.
2. Click on the Real-Time tab.
3. Select the calculation you want to archive.
4. Click the three dots "(...)" and select Archive.