Summary Table: Calculated parameters with Blockly

| Introduction

With Blockly, users can define calculated parameters by selecting and combining predefined point parameters or variables from the summary table using a query mechanism. Moreover, Blockly would provide a visual interface where users can drag and drop blocks to construct formulas without the need for any coding knowledge. Summary tables with blockly enabled helps the user to build formulas on top of the loop conditions such as calculating the delta between sensor points and setpoints, calculating chiller tonnage, etc. Some advantages include:

Clearer Understanding: Visual representations facilitate understanding of relationships and patterns in data, aiding in deeper insights.
Improved Decision Making: Utilizing visual aids to identify trends, anomalies, and potential issues empowers users to make data-driven decisions with greater insight and clarity.
Increased Engagement: Combining interactive visualizations with customizable formulas fosters user engagement and encourages data exploration, promoting an active and data-driven approach to analysis.
Democratized Data Analysis: The visual, block-based interface of the Blockly framework for crafting calculations empowers users of diverse technical backgrounds to participate in data analysis, broadening accessibility to a broader spectrum of stakeholders.

| Summary Table with Blockly

Creating a New Summary Table

From the Internal Portal,

Click Add Summary Table

Click Create New Summary table.

Select the required tags and fill in the particulars.

Select Add Calculated Parameters to add calculated parameters to the table.

The blockly sequence is displayed by clicking the calculator icon.

Edit the name for the summary table
Use the blockly blocks to compute and display the calculated parameters, as below

Click Save to save and confirm the calculation blocks built.
Click Back to Parameters to go back to the parameters addition screen.

The parameters addition screen displays

Click Create New Summary Table to confirm the table created.

The created summary table with calculated parameter displays as below in the site overview screen, when ebabled for display.

Editing a Summary Table

Click the Edit icon to edit a Summary table name.

A pop up is displayed.

editing st1.png

Click Continue to edit the table.

edit pop up2.png

Add new parameters based on the requirement.

Use the blockly blocks to modify the calculated parameters, as below.

Click Save to save and confirm the calculation blocks built.
Click Back to Parameters to go back to the parameters addition screen.

Click Update Summary Table to update the summary table once edited.
Click Create a New Summary Table to create a new summary table with the same parameters.

The modified summary table with calculated parameter displays as below in the site overview screen, when ebabled for display.