Search the Community

I have made a dashboard on which I would like to display a table of values and the accompanying graph. Both pieces of content come from the same workbench. Both pieces are set on the same date range (1 day) and are both on an auto updating schedule set to refresh every minute. The problem is that the content seems accurate the first time you load the page (sometimes)... but will not continue to update. These screenshots were taken at the same time. The tables are both a simple table and a condition table that come from the same workbench as the trend. They always show drastically different value where the trends are much more accurate. Any help would be greatly appreciated

We often would like to summarize data in a table to reflect something similar to below: There are a couple ways to achieve this in Seeq. In this example, we'll explore using Simple Table view to get this result. If you're interested instead in using Conditional Scorecard Metrics, I would take a look at this Seeq.org post! Step 1: Goto Table view & Select Simple Under Columns, ensure Average, Last Value, and Name are selected Step 2: Rearrange & rename the Headers; Last can be moved to 2nd column and renamed to Current. Avg (now 3rd column) can be renamed to 1 hr avg. Step 3: Copy the link and paste it into an organizer topic. Create a new Date Range named 1 hr (with a duration of 1 hr) to assign to your table. After clicking the table & Update Seeq Content: Step 4: Can be done on the same worksheet, or a new worksheet. I will create a new worksheet. Back to Simple table, remove the Name column so only Average is selected. Rename this column to 24 hr avg. Step 5: Paste this worksheet into your organizer next to your other table. Create another Date Range named 24 hr (with a duration of 24 hr) to assign to this newly added table (similar to Step 3). Step 6: Click each table to then click the Toggle Margin button. When complete, the table should look like one single table. To update the date range for the entire table, simply click the "Step to current time signal" next to Fixed Date Ranges.

Hi, My aim is to create an organizer topic with a metric that shows the forecast when a signal will cross a threshold. Is there a way to do this? Or is there another way where I can show in a Date format of when a certain signal is forecasted to cross a threshold that I can insert and automatically update in the organizer.

Summary: I want to create a process variable monitoring dashboard to view the trends over the last day against various threshold values. Solution: To create the monitoring charts to be included in the dashboard, follow the methods described in this seeq.org post: Then follow the steps below to create your dashboard. Step 1. Create a new Organizer Topic. From the Seeq home screen, click the "New" drop down and select "Organizer Topic". Step 2. Use the "Insert Table" button to insert a table with an many row and columns as you would like charts in your dashboard. Step 3. Use the table formatting options (available by clicking into the cell in the table or highlighting multiple cells) to merge the top row to create a title row if desired. From the table formatting options, you can also change the background color of the cell. Step 4. Click into the cell that you want to insert your Seeq trend into and, with your cursor in the cell, use the Seeq Q logo to insert Seeq content. Alternatively, insert your content anywhere in your Topic and cut and paste the content into the correct cell in the table. Step 5. Repeat step 4 for each monitoring chart you want to view in your dashboard. Step 6. Create a custom date range to apply to the Seeq content in your dashboard. This example shows how to create a daily date range that reports from 6AM the previous day to 6AM the current day, with a daily auto-update frequency to ensure the correct dates are always displayed. Click the + icon in the Date Ranges panel to open a new custom date range window. Then click the + sign next to "Optionally choose a capsule within the time window to define the date range". Create a new periodic condition of Daily duration. Optionally shift the start time of the capsules to whatever you would like to see as the start time on your daily charts (in this case shifting by 6 hours from midnight = 6AM). Don't forget to click Execute! Select the capsule offset by 1 from the end to get the capsule going from 6AM yesterday to 6AM the current day. Click save when complete and all charts will adjust to the configured date range. To configure auto-updates, check the auto-update box and set the rate to 1 day. Step 7. Share your dashboard with your peers, either via presentation view or a PDF. Presentation View: PDF:

Hi there, I have made a dashboard using worksheet, and organizer topic. Now i need to make similar design for 5 more pads. I understand that datalab can help. But right now I dont have that set up and the deadline is in 2 weeks. I wonder if there is some other tips can help. I have used boundaries, scorecard, and each signal has its operating range. Any tips can accelerate my workflow will be appreciated. Thank you

It is often useful to create a scorecard metric that displays a signal name for use in Organzier Topics. This is relatively simple using Formula and the toSignal() function. This Formula creates a string signal that has a value of "Signal Name" for all of time. After I have my string signal, I can use a simple scorecard metric with no statistics to create a scorecard that just displays the value of this string. I have changed the header to only display the end time. Now, I can use this scorecard in an auto-updating Organizer Topic that will always show "Signal Name". This functionality is very useful if you want to create a string signal that has more than one value. For example, say that I have three signals. I want to create a scorecard metric that tells me which of these three signals is the largest at any point in time. I will start by creating conditions for when each signal is larger than the other two. First, I use Deviation Search to find when Signal 1 > Signal 2 and for when Signal 1 > Signal 3. Then I use Composite Condition (logic: intersection), to find when Signal 1 is max. I repeat this process for Signal 2 - Deviation Search to find Signal 2 > Signal 1 and Signal 2 > Signal 3 + composite condition. Finally, I use Formula to find when Signal 3 is max by using union() and inverse() to find when Signal 1 or 2 are not max : $1max.union($2max).inverse(). Now I have 3 conditions which should cover the whole time series, which are true when each Signal is the maximum of the 3 at any point! I'm now ready to create the string signal. Just like I did for a single string, I will essentially be creating new signals with toString(), but this time, I will use splice() to splice in the different strings ("1 is max", "2 is max", or "3 is max") when each condition is present. This works because my "X is max" conditions will never overlap. The result is a string signal that equals whatever signal is the maximum at every point in time! Finally, I'll use Simple Scorecard again to create a metric that displays this Max Signal for use in Organizer Topics.

Question: I have a condition with multiple properties that I have displayed in the capsules pane. Is there a way to get the data from the capsules pane into a Seeq Organizer Topic? Solution: Create a new string signal for each property that you are interested in displaying in your Organizer Topic, then create a scorecard that displays those values in a table that can be added to Organizer Topic. 1. Use Formula to create a new string signal with a value equal to the capsule data for a certain property. The formula syntax to do this is: $YourCondition.removeLongerThan(1d).transformToSamples($cap -> Sample($cap.getStart(),$cap.getProperty('Product')), 2d).toStep() 2. Duplicate step 1 for each of the other capsule properties that you are interested in. The best way to do this is by using the duplicate button found in the item properties for your new string signal. This will automatically open a new formula window with the same formula from the string signal that you created in step 1. All you need to do in the new formula window is change the name and change the property that you want to create a new signal from. 3. Repeat step 2 for each capsule property that you would like to be able to display in your organizer topic. 4. Now you can create a scorecard that displays the value of each string signal over each capsule. Switch to Scorecard View using the green drop down at the top of the Display Pane. 5. Click “Add a Metric” from the center of the display pane and populate the Scorecard Metric Tool input with your string signal, your condition with the properties, and the statistic Value at End (note Value at Start will also work since this is a string tag and the value is constant across each capsule). You’ll then see a single row in your scorecard like below. You can change the format that the column headers are displayed from the headers dropdown in the top of the display. Here I have selected to display only the start time as the header and selected the first pre-defined date format. 6. Follow the same calculation duplication method described in step 2 to create a new metric for each capsule property you want to display in your organizer topic. Make sure to change the Scorecard metric name and item to measure (input signal) each time. 7. Now add your score card to an Organizer Topic and configure custom date ranges as desired.

Sometimes it is helpful to show the date range of the Seeq content used in an Organizer Topic that is shown in the topic itself. One way to do this and reduce manual updates to the topic is to leverage a scorecard to achieve an auto-updating date range. The the below steps detail how to create a date range scorecard metric: 1) Create a string signal with descriptive text using formula. The string will be displayed in the scorecard. "Current Date Range".toSignal() 2) Create a simple scorecard metric that measures the string signal created in step 1. The result is a scorecard metric showing the date range in the header and the descriptive text in the cell. 3) Remove the column with the scorecard metric name by selecting the green "x" at the top of the metric. 4) Insert the scorecard into the Organizer Topic and apply the desired date range. The scorecard will reflect the date range configured and applied from the Topic.

Hello, I was wondering if there is a way to share a topic I have created using the presentation link with someone who doesn't have a Seeq account. I want to be able to click on a link and have it take me directly to the presentation view of my topic without having to actively log in. I don't mind sending the login credentials within the link (I can use a dummy account that has minimal access). Can this be done? Cheers, Yoni