- Bin the x-axis

- Span the y-axis for each bin (max-min)

- Filter outliers based on quantiles

- Finally I would want to fit some polynomial curve based on max and min values of the span (join the mid values in each bin)

But I cant find appropriate way to do it

]]>]]>

I am trying to build a syntax using KEEP function. But I am getting error. Any help would be appreciated.

I am new on SEEQ.

]]>

Is it applicable to do that ? is there a version to be able to download with trail ?

Thanks.

]]>I'm trying to look at an organizer's content but for some reason when the organizer is opened/or refreshed using the daily or monthly refresh, the content within the organizer does not load and produces a "content capture timed out" error. However, where the content is inherited, the analyses show in the workbench. Does anyone know why this is happening or what could be causing the issue?

]]>

I have a signal (UAValue) that I want to present as a kind of histogram, but in a line diagram rather than a bar chart. The histogram should be based on a second signal (Power). I have created a standard histogram i Seeq like this (disregard from the monthly aggregation for the moment):

Each bin is 500 units wide.

The diagram I want to have looks like this (created in Power BI):

I have got as far as creating a signal (Power_I) where the values are rounded to nearest 500, but I'm stuck on how to create a signal where an average of UAValue is calculated for each value in Power_I. I also want to aggregate on year (or rather heating season, July to June) and add a reference curve.

What is the best approach to achieve this?

]]>I would like to export a table I created in workbench to PowerBI. is there any way to automate this and make it auto-refresh? Currently, I am copying the table and pasting it in an excel file which is linked to PowerBI, but that is a nuicance.

Will OData work here or is it only for signals?

Thanks.

]]>"capsule('August 15 2023 21:00', 'August 17 2023 17:00')"

Do I need to define the asset?

Thanks

]]>]]>

I'm trying to make a new template in the Organizer, and followed these instructions:

Not sure what I'm doing wrong, but my result is a new template which only says "This application requires JavaScript. Here are instructions on how to enable JavaScript in your web browser."

Thanks in advance 🙂

]]>

```
$allSignals = combinewith($p1fr.move(1ns),
$p2fr.move(2ns),
$p3fr.move(3ns),
$p4fr.move(4ns))
$allSignals.aggregate(median(),hours(),durationkey())
```

The first part of the formula combines all the samples from your signals of interest into a new single signal which has all of the datapoints from the first four signals. One trick with the **combinewith() **function is that it can't combine samples that occur at the exact same timestamp. Since I am using data from a csv file for this example where the timestamps for all 4 signals are exactly the same I use the **move() **function to slightly offset each of the signals by a nanosecond so that they all combine smoothly.

The final part of the formula is the aggregation where we can calculate the median value of our new combined signals which has all the sample form our prior 4 signals. In this example I am calculating an hourly median but this can be changed to daily() or a calculated condition that makes the most sense for your application.

]]>

i defined some conditions, using identify->value search, etc, which is very convenient and easy to get started

but i'd like to update this definition or add other criteria. this could be easily done using formula.

i see we can duplicate to formula, is it also possible to convert to formula?

thank you

]]>

Is there any way to create a scalar during an upload of Asset Tree. Looking at Tanks Levels and would like to Create PvHi and PvLo at the same time

Level 6 | Name | Friendly Name | Datasource Name | ID | Type |

A | EXP.LI42CPW.P | Process Variable | Stored Signal | ||

Scalar here | PVHIHI | LiteralScalar | |||

B | EXP.LI44SUMP.P | Process Variable | Stored Signal | ||

Scalar here | PVHIHI | LiteralScalar | |||

C | DGP.LI30BNK1.P | Process Variable | Stored Signal | ||

Scalar here | PVHIHI | LiteralScalar |

]]>

]]>

I will start by explaining what i’m trying to do. Referring to the pictures:

1- Flow: actual real-time flow.

2- Design flow: a formula i created and typed a number, for example “188”.

3- Percent: (Actual flow/Design flow)*100.

I also created some conditions to define when the equipment is running, and a periodic daily condition.

Basically, I want to display the “Percent” value when the equipment is running only. I have created a table to find its daily average during the daily condition, but the problem is that the values gets mixed with when the equipment is not running.

For example, in one of the pictures, I’m getting a percentage of 39%, while it should be around 60%. The reason for the low percentage is that the algorithm included the time the equipment was not running.

Any recommendations?

]]>

I want to identify representative capsules based on the capsule duration.

What I did so far is:

1. Identify capsules

2. Create a signal from condition that represents the capsule duration.

3. Calculate average capsule duration and percentiles of interest from this signal using metrics

4. Use these metrics to identify capsules that are within a certain range around the average or between two percentiles.

What I would like to do next and could not accomplish so far is:

By now step 4 works when entering the respective criterion to a value search by hand. Now I would like to do that dynamically, i.e., calculate the metrics for the displayed time range and directly get capsules that satisfy the criterion given above. After trying around for some time, this seems to be possible using formula: I tried to use the metrics directly, but the function I tried to use (InBetween) does not accept metrics as input. I also tried to calculate the metrics directly in formula to avoid wrong data types, but that was also not successful. It sems to get down to explicitly convert the signal metrics to scalar, but I also fail to do that.

As I am quite new to seeq, I would appreciate if there were some hints on this: Is it possible? Did I choose the correct approach? Are there other, even simpler ways to accomplish that.

Thanks in advance!

]]>]]>

1-Aug | 2-Aug | 3-Aug | 4-Aug | 5-Aug | |

Sample 1 | 8 | 7 | 5 | 7 | 8 |

Sample 2 | 4 | 3 | 2 | 6 | 9 |

Sample 3 | 3 | 2 | 4 | 5 | |

Sample 4 | 8 | 4 | |||

Sample 5 | 3 |

the signal doesn't contain sample numbers, but "sample 1" would be the first sample taken each day and then the number would increase until the next day begins.

So far I've been able to create a table showing all sample values for one day like this using the formula $signal.toDiscrete.toCapsules

I'm not able to figure out how to give each capsule a sample number or how to display different days as different columns.

]]>

For example, this will be useful in a typical XY plot analysis with a curve fit function overlaid to the data data points.

Is there any simple trick on capsules/conditions that can be utilized to make the Training window to always default to the current display/investigation range ?

Alternatively, can we utilize a date/time formula for the user to adjust it from the details pane ?

]]>

I am new on SEEQ. I am looking for creating a color code based on my two String Value in Table & Charts. Can I do that ?

]]>I have a bad actor pump that requires relatively frequent maintenance and replacement. I am using a flow measurement in Seeq to indicate whether my pump is operating or not but I'm having trouble creating a new signal that captures the running hours/days of my pump at any given time. I was able to use Signal from Condition to give me each operating periods total duration (see attached) but I'm looking for a more continuous signal.

Please let me know if there is a way to accomplish this in Seeq.

]]>Since the samples in the raw data (below image) is not always right on the whole hour I want to use the value from this signal on the half hours and shift that value 90 minutes back to the previous whole hour.

So I want the value of the step signal below from 14:30 to be placed at exactly 13:00 in my new signal. And 15:30 -> 14:00 and so on.

How would i go about that?

]]>
$capsule = capsule(now() - 1month, now())

$selected = $batch_condition.toGroup($capsule,CapsuleBoundary.EnclosedBy).pick(-20)

$earliest_start = $selected.startKey()

$batch_condition.removeLongerThan(40h).keep('Start',isGreaterThanOrEqualTo($earliest_start))

Is there any way I can fix this issue or get the most recent 20 batches another way?

]]>