Adding and Modifying Formulas
Enhance your data analysis with Proqio’s Formula feature. This capability allows users to create custom calculations from instrument readings, combine multiple parameters into derived metrics, and automatically update results in real-time empowering more accurate insights, advanced monitoring, and informed decision-making.
Module Overview: Formulas in Proqio
PROQIO’s Formula feature enables you to create custom calculations from raw instrument data, generate derived parameters, and apply advanced analytics directly within your project. This allows you to enrich your monitoring setup with meaningful metrics, automate complex calculations, and maintain accuracy across both real-time and historical datasets.
In this module, you will learn how to:
What This is Useful For
The ability to add and modify formulas is valuable in several scenarios:
-
Engineering Calculations – By using raw data fields and calibrated values, users can perform engineering calculations to derive meaningful parameters for analysis and reporting.
-
Improved Accuracy – Updating formulas when methodologies change ensures that results always reflect the most correct information.
-
Historical Consistency – Recalculating past data to which relevant formulas have been applied provides a complete, corrected timeline of derived values.
-
Decision Support – Refined formulas enable better monitoring, threshold alerts, and predictive analysis.
Adding New Formulas
To create a new formula in Proqio:
-
Navigate to Monitoring > Categories
-
Select the instrument category for which you want to apply the formula.
-
Go to the Model section.
-
-
Go to Calculated Field
-
In the Calculated Field section, enter the required details such as Formula Name, Description, and Unit in their respective fields.
-
-
Define the Formula
-
In the Editors box, write your formula using available raw data fields and calibrated values.
-
You can incorporate mathematical functions and operators listed below the editor to build a more precise calculation.
-
-
Save the Formula
-
Once complete, click the Add Formula button.
-
The formula will be created and applied to the selected category of instruments.
-
Modifying Existing Formulas
You can update or refine existing formulas in Proqio by following these steps:
-
Navigate to Monitoring > Categories
-
Select the instrument category that contains the formula you want to update.
-
Open the Model section.
-
-
Locate the Formula
-
In the Added Formula section, identify the formula you wish to modify.
-
Click the three-dot menu next to it and select Edit.
-
-
Edit Formula Details
-
Update the name, description, or unit as required.
-
In the Editor box, revise the calculation by incorporating raw fields, calibrated values, or additional mathematical functions.
-
-
Save Changes
-
Click Save to apply the modifications.
-
The revised formula will automatically be applied to all future incoming data.
-
Recalculating Data
The Recalculate Data feature in Proqio allows you to update historical records after modifying or adding formulas. This ensures that past data reflects the latest calculations, providing more accurate insights for trend analysis and reporting.
To trigger recalculation of historical data after updating a formula:
-
Navigate to the Instrument
-
Go to Layers > Monitoring > Instruments.
-
Select the instrument for which the formula has been updated.
-
Click the Details button at the top-right of the graph to open the sensor details page.
-
In the History section, click the three-dot menu on the right side and select Recalculate.
-
-
Access and Configure Recalculation
-
A Recalculate dialog box will appear.
-
Select the date from which recalculation should begin.
-
Click the Recalculate button to start the process.
-
-
Review Updated Data
-
Once recalculation is complete, the data timeline will display the updated values.
-
All future analyses, reports, and visualizations will use the revised dataset.
-