Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


Teddy last won the day on August 10 2021

Teddy had the most liked content!


Personal Information

  • Company
  • Title
    Analytics Engineer

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

Teddy's Achievements


Apprentice (3/14)

  • Dedicated Rare
  • First Post
  • Collaborator Rare
  • Conversation Starter
  • Week One Done

Recent Badges



  1. Can you explain in more detail how you are calculating residence time? It sounds like you are doing something more complicated than Volume/Flow.
  2. Ayub, It looks like dash or jupyter-dash is creating/hosting a web server to view the data from. It will be difficult to implement this on a Datalab server because of all the network and containerization complexities you would need to navigate. As long as you have a Datalab license you can authenticate and use spy (Seeq Python) from any IDE. Since the spy library can be imported into any IDE, I suggest running this locally or creating a server to host it so others can access your work. Regards, Teddy
  3. I ran some tests on R54 and everything worked as expected. I suggest opening a support ticket here (https://seeq.atlassian.net/servicedesk/customer/portal/3) so someone can take a closer look at what is going on. I would attach a link to this post in the ticket.
  4. Are you creating new signals during your updating? If you are creating new signals you will need to create a new export from the export tab. I tested formula changes on an OData connection to excel and it worked fine for me. I don’t have a Power BI license to test with. What version are you on? I can run a test on the same version to check. Teddy
  5. Feng, Do you connect to Seeq through a VPN? I am guessing this is a firewall issue and you are trying to send the data outside the firewall but I cannot say for certain with out knowing more about the architecture. Teddy
  6. To change the text in a document you would need to alter the HTML. It could probably be automated with spy.workbooks but it would be a lot of work. Also, if you wanted to copy the report and reuse it you would need to create a new script or make an addition to the script to separately handle the HTML for the new topic since they won’t be the same. I am not sure what version you are on but in newer versions you have the ability to make a date range as a text label. This feature might be what you are looking for. See screenshot below.
  7. Please note that R Squared is a discrete calculation it would be better to write the formula as follows: $ym = $signal.toDiscrete().aggregate(average(), $days, startkey()).toStep() $total = (($signal.toDiscrete()-$ym)^2).aggregate(sum(), $days, startkey()) $residual = (($signal.toDiscrete()-$prediction)^2).aggregate(sum(), $days, startkey()) $r2 = (1-($residual/$total)).toStep() return $r2
  8. Dan, Currently there is no option to append items using the spy.push command. I recommend pushing to a new worksheet and then adding the items manually through the data tab in order to not overwrite your current work. To push to a new worksheet you can set the worksheet parameter to None. spy.push(data=CapsuleData, metadata=pd.DataFrame([{ 'Name': 'Capsules Times', 'Type': 'Condition', 'Maximum Duration': '1d' }]), workbook='Practice', worksheet=None) I will attach a copy of your post to the feature request. Regards, Teddy
  9. It might be worth trying out Seeq’s OData export. Excel supports an OData feed so you can send data to Excel from Seeq with OData. I believe the live updating OData feed may require additional licensing. Here is a link to the OData documentation. https://support.seeq.com/space/KB/112868662/OData Export
  10. Writing it like the following is only supported for scalars: max($a,$b,$c,$d) If you want to use signals you will need to write it this. $signalA.max($signalB).max($signalC)....
  11. It looks like Graphviz can only be installed through an OS apt package which is not supported in Seeq Data Lab. I am guessing what is on PyPI is just a python wrapper. You can try installing Graphviz on your local machine where you have access to make OS-level changes. Since you have a data lab license the SPy library will work for you on your local machine after you run the SPy.login command. You can run SPy from any python interpreter you would like if you are running it locally. There are a few things the local version can’t do that the data lab server can but for the most part, you won’t notice a difference.
  12. Siang, Looks like graphviz is available on pypi. I would try the following to install it. pip install graphviz You should not need the sudo command. Regards, Teddy
  13. Since the reported vulnerability in log4j we have responded to several customer tickets and emails inquiring about the presence of log4j in Seeq. No recent version of Seeq (back to and including R50) either includes or uses log4j, therefore the issue does not apply to Seeq customers using recent versions of the software (your version of Seeq can be found in the lower left corner of the Seeq user interface).
  • Create New...