How to create a 'signal from condition' using formula tool

[Dylan Ooi]

Hi,

I am currently trying to build a dashboard on Seeq using a script on excel, however everything needs to be done as a formula. So I was wondering if anyone knew how to create a 'signal from condition' using only the formula tool in 1 line of code.

Cheers

[Thorsten Vogt]

Hi Dylan, 

you can use the aggregate function for this:

$signal.aggregate(average(), ($signal > 90).removeLongerThan(1wk), durationKey())

In this example the average of the signal is calculated whenever its value is above 90 and the result is drawn as a line over the duration of each capsule. You can find more information on the function and its parameters inside formula documentation.

Hope this helps.

Regards,

Thorsten

[Andrew Fontenot]

You could also create the signal in Seeq using the Signal From Condition tool, then select Item Properties for that signal to view the formula. You could do the same for the condition referred to in the formula and replace $capsules with the condition's formula.

 

[Dylan Ooi]

Thanks for the responses everyone it solved my problem!