Joanna Zinsli

Hi Lucas,

Table grouping and aggregations will be available in R64, to release in a few weeks. You can read more about the capabilities at these pages https://support.seeq.com/kb/latest/cloud/what-s-new & https://support.seeq.com/kb/latest/cloud/tables-charts#id-(R64)Tables&Charts-GroupingandAggregating. I think this will fit your needs well to have a table of capsules with each failure, then group by the failure column. You can aggregate a count or sum all the capsule durations when you've grouped.

There's also an alternative Dashboard interface in Organizer in this upcoming release. While you cannot yet limit the table to top 5 (or N), tables inserted in Organizer Dashboards have a max height. This means you could configure it so that only 5 rows show and viewers can scroll to see the other rows (or not if not relevant). You can see that on the What's New page linked above or read more at https://support.seeq.com/kb/latest/cloud/inserting-content-dashboards 

I do not expect transform() to help in the mean time. The transform() function is used to create a new signal or condition by applying a transformation to each element of an input series, such as a signal or condition. It operates on individual samples or capsules and does not provide aggregation capabilities like counting. My guess is it would be great to grab individual capsules but might be very complicated, if not possible, to group by properties and extract information that way.

Hi Emil,

Thanks for reporting this issue. I will reach out to you to review the HTML you were trying to add as a template and revert back here with general learnings. Were you trying to insert javascript into the HTML after copying from Organizer?

Another approach could be to skip the text editor all together and use Data Lab. I've attached a notebook for Adding New Organizer Templates that you can upload to any project, update cell 2 with a template name and source Organizer URL, then execute. The Archiving Templates notebook may come in handy as well since you've got one that has issues.

Thanks,

Joanna

Adding New Organizer Templates (1).ipynb Archiving Organizer Templates (2).ipynb

Also check your Chrome settings, depending on how many tabs you have open at any given time. Chrome recently added functionality to free up memory from inactive tabs. If you have an auto updating document that isn't your main tab and have this setting enabled, the document will not really be considered "live" because this Chrome setting is preventing the schedule from updating. It should update once you click back on it, but may appear stale at first. 

I've disabled this in my Performance Settings below (first box). You could consider always keeping Seeq sites active in the second box.

PDFs emailed from Organizer do not yet support different layouts or page sizes.

I have created a feature request on your behalf. Thank you for your input!

Hi Kate,

If you are on a version that supports interactive content in Organizer, the dates displayed in interactive content will also follow your browser settings. Trends are interactive in Organizer in R57 and later. Read more about interactive content over various versions at this KB link https://seeq.atlassian.net/wiki/spaces/KB/pages/146636972/Inserting+Seeq+Content#Set-Content-Properties[inlineExtension] or What's New in R57 https://seeq.atlassian.net/wiki/spaces/KB/pages/2344943627/What's+New+in+R57.

Hi Corey. I have not been able to get the same outcome on my side when I create nested calculations in an asset group, but someone from our team will contact you to investigate this issue with you further. Thank you for reaching out with all these details. 

Hi Corey. We did have an issue with pasting text between Journals identified in R55.4.2, but that should be addressed in R55.4.6 and later. We'll work with your Customer Success Manager to get you access to a more recent version. 

Note that it is a best practice to make signals global when you are using this Journal workflow between workbooks. Also note that Asset Groups are currently scoped to a single workbook so you likely will not be able to take advantage of an asset group between different workbooks.

That said, I'm not sure why the four signals from different assets have the same values. You might want to plot the inputs, dp - clean and flow - clean, from each of those assets to confirm that they are indeed different in the asset group, or chase up the hierarchy as needed. When I created a calculated item inside an asset group, I see different values reflected, even when I add assets after initially adding calculations. Which order did you add new assets? Calculation first or assets first?

Hi Jesse. Unfortunately you cannot yet embed a live chart from Power BI in Seeq Organizer. This is something on our roadmap, but we don't have an estimated time or release for when it would be available. I'll associate a request from you to the ticket on our side so you get updates as it progresses. 

You can drop a URL in the Organizer to send users out to the Power BI display, maybe even use an image to connect the link to so that people click on something that looks like a Power BI icon to get to that dashboard. I expect getting an image updated on a schedule through Python would be a bit of a chore, but that may be another possibility.

Pending how complex your Power BI dashboard is, you could also look into representing some of the visuals in Seeq instead using Tables and Charts or Histogram. Not the same currently, but we also plan to continue growing chart options in the future.

Since you asked, I'm curious what you'd expect to happen in the future when we do support Power BI inserts in Organizer. What would you expect to happen when you change a date range or asset selection? I'd imagine that change would be reflected on the Power BI content inserted, but would love to hear if that is not the case.

Thanks for your input! 

Hi Jesse. Thanks for this input. While text boxes cannot yet be tied to date ranges in Organizer, our team has been thinking about ways to improve the process of entering and discovering comments around data.

What some of our customers do in this scenario is have an Organizer Topic for each week, and they can navigate to a Topic representing a week in the past when they want to see what comments they had entered alongside the data. Some users duplicate that report each new week and clear out comments that may not be applicable when entering in new comments, and step the date ranges to now. This would be my recommendation for the time being.

Another route you could explore is Annotations in Workbench. They have a date/time context and can appear on the trend as a little chat bubble, but the information added there is not yet available in Organizer. We hope to bring the concepts of Annotations in Workbench and Comments entered in Organizer together some time in the future. We might reach out for more feedback from you on these ideas. 

Another approach that you can take if you don't need to know start or end times of the "active" capsules is a filtered Simple Table counting capsules. To get this summary table listing the "active" conditions in any Display Range, choose a Simple Table with the count column enabled from the Column button in the toolbar. If you also have signals in your Details pane, you will want to deselect those and only select the 9 conditions. If you only have conditions, you can exclude this Details pane selection. 

You can then filter that table using a menu that opens from the three vertical dots from the column header. Below I applied a filter for when count is greater than 0 and have only 4 rows displaying of 6 total conditions. The filter icon lets me know the table is filtered, and I can click on it to change or remove the filter. In R55 and later, percent duration and total duration are also possible column configurations in the Simple Table in addition to count. You can read more on how these table displays work on our Knowledge Base. 

Hi Adam,

We've made some changes to Organizer Topics to grow overall functionality, like more font options, inline Date and Asset Labels, and richer content in the future to replace the current fixed images. In addition to these 15 default colors in the palette color picker, you can also enter text into the color box that is a HEX code like the earlier versions supported (see image below where I've entered a light blue HEX code to color the table). 

While I hope this helps you make a better looking table in the short term, I'm noting you'd like a different set of colors out the gate with easier access. I'll create a feature request on your behalf. 

Thanks for your feedback!

Hi Dharun,

I haven't tried this with Seeq displays and Power BI, but some customers have Seeq displaying inside of other applications (including Sharepoint and other web applications developed by customers). Check out this youtube video I found on how to insert websites into a Power BI display. For this to work, you'll need an administrator to update some configuration parameters in Seeq to allow either a specific host (your Power BI domain) or any host to display Seeq content. You can link them to this KB article with more details on configuration. 

Anyone viewing the Power BI dashboard would likely also need a Seeq login and at least read permission of the Organizer Topic, otherwise I would expect the inserted browser window to show the Seeq login page.  

I hope this helps and let us know how it goes!

Joanna

Hi Rohan,

For now you will have to use your first approach. You can use the formula below to convert your string signal to a numeric signal to display. 

$dashedstring.transform(($p, $c) -> sample($c.key(),$c.value().replace('-', '')))

I was inspired by this seeq.org post and made some minor adjustments in the replace() for your use case with dashes interrupting what is otherwise a number.

In a future release (R55), strings will also display Value at Start, Value at End, or Count in Treemap (strings displayed with Example data shown below). This release will not be available for several months, so in the mean time you will need to use the approach above. Thanks for reaching out!

Hi Prachi,

What version of Seeq are you using? The answer to how you will get this display is pretty different based on Seeq version since we are making some big changes around the amount of work required to build a table. You will find more information on Seeq Tables in our Knowledge Base.

In R53, you could:

1. Identify these periods of operation with a condition (likely a condition for the first asset and a separate condition for the second asset). That condition could probably be defined by a $signal.isvalid() since you have gaps in the data, but it could also be a Manual Condition that you create.
2. With these conditions identified and in the Details Pane, you can swap to Table View, selecting the Condition table.
3a. You can add the Duration for the conditions displayed using the Column button in the toolbar, since your use case seems to be about durations of operations. 3b. Alternatively, if you already have the signal as a duration as you do, you could add the last value of the signal for each of the signals trended. This option allows you to specify units. The duration will display as days hours:minutes:seconds.

If you are on an earlier version such as R52 or earlier, you will need to use Condition Based Scorecard Metrics to get to this table view. These solutions will also work for R53, but require creating Metrics. You can also use Metrics to color the cells based on thresholds if desired. You could include the asset name in your item name so that it would display in the header.

1. Define the condition (likely same as 1 above).
2a. Create a Value at End Scorecard Metric for each of the signal/condition combinations.
2b. OR Create a Duration Scorecard Metric for each of the signal/condition combinations.

Thanks for the question and let us know if you have more questions about this approach.
 

When content is inserted into Organizer Topics, Seeq inserts the current workstep of that worksheet. There is not presently a way to pick a workstep other than the current. As changes are made to the underlying Workbook, you can opt to update the content in the Topic to use the latest workstep via the bulk edit modal or each individual content configuration pop up. If the current workstep is already present in the Topic, then the button below will not be activated to update. See the Inserting Seeq Content article in the Knowledge Base and let us know if you have more questions. 

Hi Sivaji,

Did you know you can update many pieces of content at once by clicking on the Content Count in the Properties tab of Organizer Topics? This will open up a table and let you select multiple pieces of content to which changes can be applied. One such change might be opting to update to the latest workstep from each piece of content, but you can also change date ranges, font size and more from this table. Check out this article in the Seeq Knowledge Base for more info and let us know if you have more questions. 

Hi Thorsten,

The connector configuration files are always being monitored for changes. Just adding a white space and saving the file will be seen as a change and initiate Seeq to reconnect.

You can reconnect without indexing if you want, or you could have it index depending on how the connector is configured. If the configuration file has "OnStartupAndConfigChange" set to true for this connection, any white space change will be noticed as a change and indexing will be triggered on save. Alternatively, you could have this parameter be false and set the date/time in "Next" to be some time in the past. Then when saved, the connector will realize it needs to index as the next scheduled date is in the past and will find and index the connection. If this parameter is false and the date/time is in the future, the connection will be attempted again on save with a white space change, but indexing will not occur until the next scheduled date.

Regards,

Joanna

Hi Thorsten,

Current releases assume the connection is closed after the SQL server connection is lost and do not automatically try to connect again. Instead of restarting the Seeq service, you could edit the SQL Connector configuration file to resume a connection after the SQL server is rebooted or SQL service restarted. 

This has been addressed in an upcoming release (0.47.00). After you upgrade to this release when available, Seeq will make repeated attempts to connect to SQL servers that are appearing as disconnected so that the connection will resume when they become available again.

Thanks,

Joanna

Welcome to Seeq!

For your first question regarding creating a signal that is the max of several signals, check out the max() function in Formula and see this other seeq.org post linked below. 

As far as removing values that are above or below a threshold (like 900), search for the remove() function in Formula, and find the Signal variant. You can write a nested function as shown in the Formula help to remove values less than a threshold per below. 

$signal.remove(isLessThan(900))

For more information about how to search through Seeq's Formula documentation, see this KB article on Seeq Formula https://support.seeq.com/space/KB/143884328/Formula.

Happy Seeqing!

Seeq is often used to contextualize data with respect to production runs. These product runs may be a text or string signal that is the product code, or a very large numerical signal. Users commonly use Value Search to find a specific product run to further analyze. If they want to work with a couple of similar product runs, for example ones that start with or end with the same few letters or numbers, a few Value Searches followed by Composite Condition may be acceptable.

This approach may not be realistic if there are hundreds of different product codes to analyze. Recently a user asked for a trim function because they wanted to categorize all product codes by the first few letters the product code. For example, ABC-123-XYZ and ABC-456-DEF would both fall under the "ABC" product category. In Excel, users might use something like the functions LEFT and RIGHT to return the first few characters (LEFT(3) in this ABC example). One way to do this text or string manipulation in Seeq is to use the replace() function with a regular expression. 

Regular expressions can be intimidating to those who have not used them before, but they can also be very powerful. A little exploration on sites like https://regex101.com can help evaluate what kind of regular expression is appropriate for a specific use case.

Given the above example product codes, the below Seeq Formula incorporates a regular expression within the replace() function to parse the string signal by the "-" and then return only the first part of that parsed string based on the "$1".

$productcode.replace('/(.*)-(.*)-(.*)/', '$1')

I could similarly categorize by the last three characters with a function like

$productcode.replace('/(.*)-(.*)-(.*)/', '$3')

Once this simplified text signal is available, any other tools can be used in the analysis. If the product code was a very large number instead of a string, apply toString() to benefit from the replace() function. 

There are often many ways to solve a problem. An alternate approach to categorize product codes like this might be to pair toCapsules() and filter() off the Value property in Formula. Perhaps the best solution is incorporating regular expressions into Value Search like in the example below to create conditions any time the product code starts with ABC (/^ABC.*/) or any time it ends with XYZ (/.*XYZ$/). The slashes here indicate regular expressions should be used, similar to searching with regex in the Data Pane. 

But this approach is likely not obvious or easy without a little experience with regular expressions. So while regular expressions may feel foreign at first, do not be intimidated! They really can pay off in the long run.