Search the Community

I have a datasource that stored conditions with start and end time. Is it possible to connect to it to get dynamic capsules. Instead of importing a csv.

Background: Seeq has functions in Formula to remove outliers based on different algorithms, but sometimes it is desired to identify and remove outliers that falls outside of the interquartile range. Solution: The approach we can take to solve this data cleansing problem in Seeq is to determine the periods over which we want to calculate the quartiles, calculate new signals from the 25th and 75th percentiles during each of those periods, identify deviations from those percentiles, and remove data outside of the IQR from our original signal. 1. The first step is to decide what type of periods you would like to use to calculate your percentiles. Some periodic choices might include: hourly, daily, or a rolling window of 24 hours each hour. Other choices could be the current production run, the time since the equipment was last maintained, etc. In this example we will use an hourly periodic condition in our quartile calculations. 2. Next, use the signal from condition tool to calculate the 25th percentile during each of the capsules defined above. 3. Use the same method to calculate the 75th percentile during each of the capsules defined above. 4. Use Seeq's Formula tool to calculate the IQR. $UpperQ - $LowerQ 5. Now use Formula to calculate the upper and lower limits as for outlier removal as: $upperQ + n*$IQR (where n is a scalar multiplier, 1.5 in this example) $lowerQ - n*$IQR 6. Search for deviations from the Upper and Lower limits using Deviation Search. 7. Then use Formula to remove data during the identified outlier capsules. $signal.remove($outliers) Content Verified MAY2024

How to create a capsule every 5 days?

For reporting purposes, I want to calculate statistics based on the most recent period(capsule) and display that along with the periods immediately preceding it. This can be done in Organizer using the custom date range by creating a Periodic Condition and selecting the capsule closest to or offset by one from the end. The same date ranges or capsules relative to now can be created in Seeq Workbench as well. Organizer: Workbench: We create the same condition as the above Organizer in Workbench by following the methods below. The first method defines how to create conditions for current and previous conditions for years, days, weeks, shifts. The second method includes an extra step that is necessary for current and previous months and quarters since the exact duration of these periods can vary based on the number of days each month. Method 1 - when the length of time in each period is definitive (e.g. year, week, day, shift). This example shows how to create conditions for "Current Week" and "Previous Week" 1. Create a Periodic Condition for "Weekly" using the Periodic Condition tool. 2. Create a Condition around the current time ("Now") using Formula --> condition(1min, capsule(now() - 1min, now())) 3. Use the Composite Condition tool to create a condition for "Current Week" when the Periodic Condition "Weekly" touches the tiny capsule at "Now". 4. Use Formula to create a condition for the "Previous Week" --> $currentWeek.beforeStart(7d) Method 2 - when the length of time in each period is variable (e.g. month, quarter). This example creates a condition for "Current Month" and "Previous Month" 1. Create a Periodic Condition for "Monthly" using the Periodic Condition tool. 2. Create a Condition around the current time ("Now") using Formula --> condition(1min, capsule(now() - 1min, now())) 3. Use the Composite Condition tool to create a condition for "Current Month" when the Periodic Condition "Monthly" touches the tiny capsule at "Now". 4. Use Formula to create a Condition for the last day of the last period (in this case "Last Day of the Last Month") $currentMonth.beforeStart(1d) 5. Use the Composite Condition tool to create a condition for the "Previous Month" when the Periodic Condition "Monthly" touches the "Last Day of Last Month". Content Verified DEC2023

How can i create a time based condition for a time interval that isnt in the periodic condition tool? In this case i want to calculate a statistic for my signal (an average or max) every 15 minutes. How can i do this?

Hi all, I am based in the UK and wanted to define shift pattern that changes with time zones. I have created a condition for a 12 hour shifts that are on days for 2 consecutive days and then on nights for 2 consecutive nights. [Each shift will have 4 working days (2 days and 2 nights and 4 days off] Consider 4 shifts in this shift pattern, namely: Shift 1, Shift 2, Shift 3, Shift 4. The shift starts at 8am and ends at 20:00. After which the next shift starts at 20:00 and ends at 8:00 I am using the following formula: In the next step, I am defining my Night Shift using below formula: And then I am defining my Days Shift using below formula: After this, I combined, the days and night condition: $days.union($n) Then I defined my first shift: Shift A: I then moved the next shift by 2 days, Shift B: And then used this shift to define next one and so on, by moving each shift by 2 days from previous one. The issue I am having is that the shift is not aligned with daylight saving. Please help, I referred guide from, but doesn't work for this shift pattern

a. Add the property of the day of the year to the daily condition. 1. From Tools>>Identify select Periodic Condition >> Daily and click execute. The daily condition automatically includes the properties of the Day of the week, month and the day of the year. 2. From the Capsules pane select the required properties. b. Add the property if the week of the year to the weekly condition. 1. Use the following Formula to create a weekly condition with the property of the week of the year. round(timesince(years(),1week).tostep() + 1).toCondition('Week') 2. From the Capsules pane select the Week property.

Hello Everyone, I hope you are doing well. I need some help with creating a function. I have multiple conditions that I have created that tell me if the equipment is stopped, lag, standby, or other attributes. I want to be able to be able to: ADD Durations for when equipment is stopped and in lag OR when the equipment is stopped or standby. ADD Durations for when equipment is stopped but not in lag or standby. The example variables are in hours. Stopped ($i5) Standby($i6) Lag ($i) I would appreciate the help.

Need to clarify the difference between a "calendar month" (per an actual calendar) and a "normalized month" (365/12) Example screenshots: 1. I set the time window to 1 month, starting January 1st at 12:00am. It ends January 31st at 10:00am. This is a "normalized month" 2. I do an integral over months, UTC-12:00. It resets on the 1st of each month at 6:00am. This is a "calendar month". 3. If I manually type in "6 months," it is 1/1/2020 12:01am to 7/1/2020 1:01pm. However if I manually type in "26 weeks" it is automatically converted by Seeq to "6 months" and it is 1/1/2020 12:01am to 7/1/2020 1:01am. The length of the 6 months is different! Here's the real kicker: I manually type in 6 weeks and it is automatically converted by Seeq to "6 months". I then manually type in "6 months". The time scale doesn't change, it still ends at 7/1/2020 1:01am. So the length of the "6 months" that I entered depends on the previous state of the chart. Same thing happens for a year. One year is 365 days (or 366 days for a leap year). It is not 52 weeks * 7 days = 364 days. It would greatly help us to get these time frames resolved. Contracts and accounting run on true calendar months and years. 3 How long is six months.pdf 1 Normalized Month.pdf 2 Calendar Month.pdf

There are many use cases where the user wants to do an aggregation over a periodic time frame, but only include certain values. For instance, in this example, we aim to calculate the average daily compressor power but only when the compressor is Online. 1. First, use Value Search to identify when the compressor is ON, which in this example is when the compressor power > 0.5 kW. 2. Then, use the 'Within' function in the formula tool to filter the signal to only include samples when the compressor is ON. 3. Create daily condition using either 'Periodic Condition' or 'Formula' Tool. 4. Finally, use 'Signal from Condition' tool to calculate average daily compressor power when it's ON. Content Verified MAY2024