Asset Groups 101 - Part 2

[Patrick]

This is a continuation of the Asset Groups Part 1 post.  If you are not familiar with Seeq Asset Groups, it’s recommended to read Part 1 first.

This post explores how to configure calculations directly in an Asset Group.

In the previous post we covered how to create a basic Asset Group from a collection of unorganized tags.  By mapping these tags to an Asset as an Attribute, we can trend, swap, calculate, and visualize analytics across the configured Assets.  Once an Asset Group is configured, calculations can be generated and swapped provided they are based on the signals that were configured in the Asset Group.

Note that the calculations in Part 1 were not configured as a separate Attribute in the Asset Group, but rather are a dependency of the signals in the Asset Group. To illustrate, navigate to “Location 1” in the Asset Group created in Part 1 and note that while the two signals are listed, the newly created “High Temperature” condition is not a dedicated item in the Asset Group.  This is because the calculation was not created in the Asset Group, but instead relies on signals (Attributes) from Assets in an Asset Group.

Now let's explore how to configure calculations directly in Asset Groups.  Make sure your trend/treemap view is set to Location 1.  

(If it is not, swap the asset to Location 1 by Navigating to “Facility Temperature Monitoring” in the Data tab and clicking the swap icon next to Location 1)

 

1)    In the Data pane, click “Reset” and then edit the Asset Group created in Part 1.

2)    Click on “Add Column” followed by “Add Calculated Item”.

3)    Users are given two options for the calculation type – “Existing Seeq Item” and “Build Formula from scratch”.

Select “Existing Seeq Item”:

 

4)    A search modal will appear.  Under “Recently Accessed” you should see the previously created “High Temperature” condition.  You can also search for it by name.  Once located, select it, and click “Next” to copy the formula syntax directly into the Asset Group.  

5)    Seeq will automatically map the associated column(s) to the variable(s) in the formula syntax.  Give the Column (Attribute) a name and click “Add Calculated Item”.
 

6)    Note the new column that was added with an f(x) symbol to denote that it’s a formula rather than a mapped tag.  The formula can be viewed and edited by clicking on the f(x) icon.  Click “Save” to save the Asset Group.

7)    In the Data pane, navigate to Location 1 in the Asset Group – note the newly created condition is now listed directly in the Asset Group.  

Creating the condition directly in the Asset Group offers two main benefits:

a.    Items can be easily discovered, added, and removed from trends by navigating through the Asset Group
b.    Each Asset gets its own version of the item, meaning it can be modified to be different for each individual Asset.  More on this next.

8 ) Add the newly created condition (“High Temperature AG Condition”) to the details pane and remove the previous “High Temperature” condition.  

If you are still in Treemap view, re-assign the priority color for the new condition.

9)    Click the edit icon to edit the High Temperature AG Condition for Location 1, then change the limit from 100 to 110, and click “Execute”.

This will update the condition criteria for Location 1.  Location 2 & 3 will retain the previous limit of 100.

10)    To verify, Asset Swap to Location 2 via the Data tab and edit “High Temperature AG Condition”.

Notice the Formula for Location 2 still retains the original limit of 100.

11)    Individual Formula modifications can also be done directly in the Asset Group.  Let’s edit the Asset Group via the Data pane by clicking on the “Edit” icon.

12)    Click on the f(x) icon for Location 1 & notice the limit of 110 configured earlier.
 

13)    Close the dialog box click the f(x) for Location 2.  Note the limit is set to 100.  Let’s change it to 90 and click “Save”.

This will change the limit for Location 2.  Location 1&3 will remain unaffected, which you can verify by clicking the respective f(x) button for those locations. 

14)    Asset Group calculations can also be added without referencing a pre-existing item.  Seeq refers to this as building a Formula from scratch. To do so, click on “Add Column -> Add Calculated Item”.  

This time, select “Build Formula from scratch” from the modal.

15)    Let’s create a Low Temperature Condition that will trigger if the Temperature is less than 40 deg F.  Click the “Add Calculated Item” to add it to the Asset Group.

16)    Save the Asset Group and navigate to the Asset Group in the Data pane to verify the new condition has been added.

17)    (Optional – Seeq version R55 and later) Edit the Asset Group to add additional Assets which will automatically generate the same analysis for the added source tags.

          

You can rename the newly added assets and map underlying tags associated with the other Assets.

  

Once assets are named and tags mapped, save the updated Asset Group.

The additional Assets will be displayed in the Asset Group and can be trended, swapped, and displayed the same way.

   

Edited July 29, 2022 by Patrick
minor edits for clarity