How to get capsule properties data from the Capsules Pane into an Organizer Topic

[Allison Buenemann]

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. 

 

 

[Morgan Bowling]

In R.21.0.44 and newer versions we can now transform Capsule Properties to a signal with a more straight forward formula.  This uses the toSignal() operator:

In this case my formula would be $b.toSignal('Product', startKey()).tostep(3d)

[Mindy Johnson]

Is there a way to make switch the properties to be column headers?  In other words, how do I flip a table in the organizer topic so that each new capsule is a new row, rather than a new column?

 

Or how do I create an X,Y table to be displayed in the organizer topic?

[Lindsey.Wilcox]

@Mindy Johnson - unfortunately, it is not currently possible to display the properties as column headers; Scorecards can only be displayed in the date/time column header format.  However, this is a commonly requested feature that is logged in our system as Feature Request CRAB-15385.  I have opened a support ticket (SUP-20122) using the email address associated with your seeq.org account to link you to this development item so that you will be notified of any progress towards its implementation.

Thanks,

Lindsey