Lindsey.Wilcox

Since posting this solution, the Formula provided in Step 4B has been simplified to: $errorCond2.removeLongerThan(1week).setProperty('container', $container2, startValue())

Objective: calculate the difference between the average temperature 10 min before an event and the average temperature 10 min after an event Create a condition for 10 min before an event. This is done in Formula using the .beforeStart() operator. 2. Create a condition for 10 min after the event. This is done in Formula using the .afterEnd() operator. 3. Calculate the average during the capsules in the conditions created in Steps 1 & 2. This is done in the Signal from Condition tool. 4. Combine the 2 signals created in Step 3 into a single, combined signal. This is done in Formula using the .combineWith() operator. 5. Create a condition that contains a capsule for each event, including the 10 min before and the 10 min after. This can be done in Formula using the .move() operator 6. Calculate the range of the combined signal using the Signal from Condition tool.

Objective: calculate the time between events Method: Create a condition with the capsules when you are not in an event. This is done using the .inverse() condition in Formula. 2. Calculate the time between events using the Signal from Condition tool to calculate the duration of each capsule in the Not in Event condition.

Hi Adam- The NOAA weather connector brings in all historical and forecast data that is available. This typically includes about a 7-day forecast: Are you not observing the forecasted portion (dotted line) of the signal? Could you please provide a screenshot of what the temperature signal looks like? Thanks, Lindsey

Hi Adam- Which specific signals are you looking to get a forecast for? Lindsey

Hi Connor- Yes, you can do this using Capsule Properties. Capsule properties can be displayed as the header of Scorecard columns (in place of the start / end time). More information on this can be found here: Please let me know if you have any additional questions. Thanks, Lindsey

Hi Connor - To display the value of a signal during each capsule (event frame), you will want to create a Condition based scorecard (as you've done). However, the item to measure should be the signal. With the signal selected, you won't need to select a statistic (since you just want the value) and specify the condition (event frames) that you like to display the value for. Please let me know if you have any additional questions. Thanks, Lindsey

Hi Sivaji Unfortunately there is not a workaround to plot a vertical line for average capsule duration in Capsule Time. However, I have logged a Feature Request for this item (CRAB-24964). Additionally, I have linked you to the Feature Request via Support Ticket SUP-27734. This ensures that you will be notified of any progress towards implementation. Please let me know if you have any additional questions. Thanks, Lindsey

Hi Sivaji- You have to take a few steps to get more than ten pushed signals to display in the Worksheet, but it’s totally possible. To begin, make sure that you assign the result of spy.push to variable. Here is some example code: push_results = spy.push(data=my_data_df) # Pull the workbook. Use the URL of the Workbook where the signals where pushed 4# You can take it from the output of the above command url = 'https://explore.seeq.com/36202737-B32E-463B-A583-202BD4D8A7AB/workbook/6D2D5190-3A28-4E60-B9AD-F4DCE35ACD06/worksheet/904599EB-93D1-4C32-BD23-643D641EB063' wb = spy.workbooks.pull(url)[0] # get the worksheet from the workbook ws = wb.worksheets[0] # add all the pushed items to the worksheet ws.display_items = push_results # push the workbook with the modified worksheet back to Seeq spy.workbooks.push(wb)

Hi Alex- Thank you so much for all of these great suggestions! I have some comments / notes on each of your suggestions (in red). I have linked you to each of the Feature Requests (CRABs) mentioned to ensure that you are notified of any progress towards implementation. Change the x and y axis range by typing in the values. Like customise in trend view. Scrolling and dragging can be painful, particularly if I have multiple scatter plots I want to have the same range so I can show them together in Organizer. This Feature Request is already logged as CRAB-18708 Filter by a/multiple specific condition(s), not all present. This is already possible as described in the Filtering Data in Scatter Plot section of our Knowledge Base article: https://support.seeq.com/space/KB/153518135/XY%20Plot#Filtering-Data-in-a-Scatter-Plot. Once you have selected to filter the Scatter plot by condition, select the condition(s) of interest in the details pane to further customize the display: Add multiple trends to either x or y axis This Feature Request is already logged as CRAB-5295 Gradient color by time, e.g. oldest to newest as lightest to darkest. This Feature Request is already logged as CRAB-5289 Be able to edit the color by start and end ranges This is already possible as described in the Coloring Data section of our Knowledge Base article: https://support.seeq.com/space/KB/153518135/XY%20Plot#Filtering-Data-in-a-Scatter-Plot. From the color menu above the scatterplot, a start and end time can be specified to color based on fixed date ranges: Have the label show values of other signals at that timestamp. I have filed a new Feature Request for this item : CRAB-24198 Draw a freeform shape to select points from plot to make a condition - not just a rectangle. This Feature Request is already logged as CRAB-21692

Hi Sivaji- Thanks for reaching out. Yes, the top 10 signals are displayed in the worksheet by design. If more than 10 signals are pushed, they are still searchable in the workbook. If you’d like to trend more than 10 items, I’d recommend that you pull the workbook and then modify the display_items for the worksheet, and then push it back. There is not a maximum number of signals that can be plotted on a single worksheet. However, as the number of trended items increases, the more difficult it will be to actually view the data clearly and identify trends in your signals. Additionally, if a significant number of items are trended, performance may degrade as well. Please let me know if you have any additional questions. Thanks, Lindsey

Background In this use case, we start with a signal that indicates the product code as a 9-digit number. I would like to aggregate the data by product code and display the results in a histogram. The current method do this involves using the .toCondition() operator on the product code signal and then aggregating the results in the Histogram tool using the value property of the product code condition. However, when this is done, the product code bin labels are displayed in the histogram using scientific notation: However, I'd like to see the full product code; the value in scientific notation loses its meaning. This feature request is logged as CRAB-22684. This post documents the current work around. Analysis Steps 1. In Formula, convert the product code signal to a string signal and add an underscore ("_") to the end. 2. Use the .toCondition() operator to create a new condition with a capsule for every value in the string product code signal. 3. Finally, aggregate the condition created in Step 2 by the value property in the Histogram tool.

This post summarizes the use case presented during the Advanced Analytics for Sustainability webinar held in January 2021. Background Manufacturers often don’t have insight into how much water and energy their facility is actually consuming. Having a way to quickly aggregate this consumption data is important, because it provides the information necessary to determine if the process is using water and electricity efficiently when running or if the water and electricity usage is minimized when not running. The following use case shows how to perform some of these aggregations in Seeq and scale the calculations to other process units or assets. For this use case, an asset tree is leveraged. The asset tree in the following image has a separate asset for each part of the process. For this analysis, the electricity consumption tag, the water consumption tag and the mode tag are used. Analysis Aggregate consumption by mode of operation The Histogram tool is used to aggregate the consumption data by mode of operation, as described in the following steps. 1. Create a condition that contains a capsule for each mode. This can be done using the .toCondition operator in Formula. Note that each of the capsules in the Mode Condition has a 'Value' property that indicates the value of the Mode signal. These capsule properties can be used to aggregate data in the Histogram tool. 2. Use the Histogram tool to create a histogram of electricity consumption by mode of operation. 3. To create a similar histogram for water consumption, first duplicate the Electricity Consumption by Mode histogram from the Item Properties menu. Next, provide a new name and switch the input signal to create the second histogram 4. These calculations can easily be scaled to other assets using Seeq's Asset Swapping capability. With one click, the same analytics are applied to another plant area. Quantify consumption while not running Manufacturers want to minimize consumption when their processes are not running. To do this, they first need to quantify how much electricity is being consumed while not running and then identify instances of high usage. This can be achieved using the following steps. 1. Use the Value Search tool to identify when the process is not running. 2. Use the Signal from Condition tool to quantify the total amount of electricity consumed while not running. 3. Use the Value Search tool to identify when the amount of electricity consumed while not running is high. Notice that aren't any visible capsules along the top of the trend. However, if this new condition is selected in the Details Pane, one capsule is identified in the Capsules Pane, with a duration of 0. The duration of this capsule is 0 because the searched signal is discrete and there is only a single data point that exceeds the limit. 4. Since there are several areas to monitor for environmental deviations, the Treemap view can be leveraged. The color coding of the treemap indicates which plant areas have exceeded the maximum threshold and is a great way to quickly identify parts of the process that are not performing optimally.

Hi Devin- Unfortunately there is not currently a way to drop a cursor on the Scatter Plot, as you described. However, this Feature Request is already logged as CRAB-22175. I have opened a support ticket (SUP-26165) to link you to the feature request; this ensures that you will be notified of any progress towards its implementation. Thanks, Lindsey

Hi Sivaji Unfortunately, this is not currently possible as you described. However, it is a commonly requested feature (CRAB-15825), and I have linked you to the request so that you will be notified of any progress towards its implementation. As a workaround, I recommend creating a Scorecard to display the values. Please let me know if you have any additional questions. Thanks, Lindsey