Jump to content

All Activity

This stream auto-updates

  1. Yesterday
  2. I've got an excel monitoring tool that our operators will use daily. I'd like to be able to build a functionality within the excel tool for pulling data directly from SEEQ into the excel tool. Ideally, I could build some VBA query that works in the background to pull the data from SEEQ using the API, and our operators just click a button to run the VBA code that will query the SEEQ API. Is there a way to do this? To pull data directly from SEEQ without leaving the EXCEL environment?
  3. Last week
  4. Hi Matthias, I would recommend checking out this post, which follows the same process: When looking at that post, it sounds like you'll want the $reset variable to be equal to a monthly condition.
  5. Hello, I would like to determine the mass [kg] per month of the shown signal. The signal is a sum counter. The problem is that the signal only counts up to 1.0e+7 kg and then drops down to 27kg (sometimes 9kg or different values). I guess I have to start to somehow identify the max and min peaks, calculate the difference for each drop and then summarize this over the month. This is the theory - but how does it work in practice? Thank you.
  6. Earlier
  7. Psychrometric charts are used for cooling tower and combustion calculations. For users that have weather data, this could give people a better idea of how their cooling towers etc. It might make sense to include them in formula in the future. thanks!
  8. Hi John, If i am understanding correctly- you have data with one signal having multiple values at the same timestamp. Seeq does not support multiple values existing at the same time stamp for signal based data- it will only take one of the values and display that. To get this kind of data to be workable we have 3 options: You can adjust the timestamps of the other datapoints by some small amount so you can see all samples in the same signal, just slightly offset in time You can bring each measured value in as its own signal i.e. product qulaity x measurement 1, quality x measurement 2, etc You can bring this data in as an event (condition) with properties- You can have one capsule per product sample and that capsule can have properties that contain each measurement value as well as any other information about the measurement you might be interested in. Reach out to seeq support support@seeq.com if you want help exploring some of these options further -Sean
  9. In our QA process, we take product samples and make measurements for critical process parameters. For the data this produces, all measurement readings for a single QA sample have a single timestamp. Since this seems like it may be pretty common across manufacturers, I am wondering options for bringing this into Seeq without losing the granularity of the raw data. When we import the raw values, it seems like Seeq is automatically averaging all of the points. We can aggregate the samples in the backend database by doing statistical aggregations in the back-end SQL, but then we also lose the granularity of the raw sample readings. I would gladly appreciate any thought or suggestions on the best way to handle this.
  10. Hi Onyekachi, The only way to implement this is with a polling loop. Seeq is a lazily-evaluating system, meaning that no data pull or calculation is performed without a query driven either via the UI or our API. There are examples of customers implementing polling loops to query for new data/capsules and push the results of that query on a messaging infrastructure such as Kafka, Kinesis, etc... This is generally performed using our Seeq Python library Spy. Regards, Chris
  11. Eric, There is not currently a way to add stats to the capsule panel. What kind of statistics are you interested in adding?
  12. We often get asked how to install the Add-ons from the open-source Seeq Add-on Gallery (https://seeq12.github.io/gallery/). First, you'll need a Seeq administrator for your company as an administrator is required to install a new Add-on. Then, each Add-on has specific instructions linked it's documentation page linked from the Add-on Gallery. For example, you can click on the "Documentation for Correlation Add-on" to get to the documentation for the Correlation Add-on: On the left hand side, there's an installation section: From there, simply ensure all the requirements are met and follow the instructions listed: If you run into any issues or want to file a feature request, use the GitHub page also linked from the Seeq Add-on Gallery to file an issue:
  13. Yes, in Data Lab users can use spy.pull to get the data and then write it to S3. See attached notebook example written by @Chris Herrera that shows an example of how to write data to S3. Disclaimer: User will have to add their own credentials and unlimited performance is not a guarantee. Reach out to support@seeq.com if your use case is not performing up to your expectations. Publish to S3.ipynb
  14. Hi RMC, I have "been there done that!" Now there is an archive parameter which when set to True will only keep the items from your push the unwanted "append" will not occur. Instead it will give you exactly what you are pushing and archive the rest.
  15. Hi there, I have a jupyter notebook to set up and comb through some data and set up a custom asset tree and workbook on a regular basis. This asset tree is new every interval, but currently it just adds the new assets to the ones that were created on the previous interval, basically like appending a list. What I'd like is to completely delete the asset tree from the last interval and start over. This can easily be done through the seeq interface, but I'd like to have it code based in SDL so I can just re-run my jupyter notebook every week and get the workbook I need. Thanks for any help!
  16. Hi All, I am new to SeeQ and wondering if SeeQ has an event messaging workflow where alerts can be sent out automatically. Thank you.
  17. Is it possible to add your own user defined summary statistic (min,max, etc) for a capsule to roll out to workbench?
  18. The Scorecard tool does not have all of the timezone options in it and instead uses the default server time. The easy work around is to create a monthly condition using the Periodic Condition Tool with our desired timezone and then switch your Scorecard to a "Condition" type using that new monthly condition.
  19. I used Quantify>>Scorecard Metric to calculate a monthly average of a daily average signal, which starts at 12:00AM each day. However, the monthly average signal starts at 5:00PM everyday, is there a way by which I can change it to 12:00AM? If I use runningAggregate in formula, I do not have this problem.
  20. Here is another related post.
  21. We don't currently support it, but we've noted the desires for the 2D use cases. Without committing to a specific release or date, I'll say it is on our near term roadmap 🙂
  22. Yes! You can deploy ipywidgets from jupyter notebooks in data lab. Widgets can be great for wrapping code in UI for No-code experience from workbench using Seeq Add-on tools for implementing Machine Learning models. Here is one example for datepicker. import ipywidgets as widgets #import the library widgets.DatePicker( description='Start:', style={'description_width': '150px'}, layout={'width': '300px'}) You can read more about various widgets here: https://ipywidgets.readthedocs.io/en/latest/examples/Widget List.html
  23. Dear all, I have found that 1D lookup tables (1 independent variable mapping to 1 dependent variable) with linear interpolation can be used in Seeq. Is there also a functionality for 2D lookup tables (2 independent variables mapping to 1 dependent variable)? For those who are familiar with Matlab, I am looking for an equivalent of the 'interp2' Matlab function. Many thanks in advance. Filip
  24. Hi, the error means that you are referencing a variable that is not defined in your variable list. You should change your variable "$signal1" in the formula to a variable you have in your variables list: Also be aware that you cannot use a signal and a condition together on combineWith(). You can combine either signals only or conditions only. Regards, Thorsten
  25. Hi, i am trying to create a signal by using $signal1.combineWith($signal2) but unfortunately it does not work . purpose of this getting signal by creating signal of tow signal or signal of signal and condition
  1. Load more activity
  • Create New...