Tables: Calculated parameters with Blockly

| Introduction

With Blockly, users can define calculated parameters by selecting and combining predefined point parameters or variables from the 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. The tables with blockly enabled help 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.

| Tables with Blockly

Creating a New Table

From the Internal Portal,

• Click Add Table

• Click Create New Table.

• Select the required tags and fill in the particulars.

• Click Add Calculated Parameters to add calculated parameters to the table.

The blockly sequence is displayed by clicking the calculator icon.

• Use the blockly blocks to compute and display the calculated parameters, as below

• Click Save & Back to Parameters to save and confirm the calculation blocks built.

The parameters addition screen displays

• Click Create New Table to confirm the table created.

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

| Applying the Table for View in Site Overview

• Check/ Select the table for applying.

The applied table can be viewed in the site overview page as shown below.