Condition Property to Signal that Spans Capsule Durations

[Ethan Holmgren]

Hi,

I have a condition (imported from CSV) containing many numeric properties that I'd like to use in a formula. So far, I've been able to pull the property data into a signal using toSignal() and toNumeric() functions:

$condition.toSignal('<Property Name>').toNumeric()

but the result is discrete data points at the beginning of each capsule. How can I modify my formula so that the resulting signal is flat lines spanning the duration of each capsule? What I'm looking for is just like the result of selecting "Duration" for "Select where to place the timestamp of the summary statistic" in a Signal from Condition except the "statistic" a specified property of each capsule.

 

Thanks,
Ethan

[Thorsten Vogt]

Hi Ethan,

you can try this:

The formula combines two signals with the property value at start an end of the capsule. By using toStep() the samples are connected and by using within() only the portion of the signal within the condition is kept.

Does this work for you?

Regards,

Thorsten

[Teddy]

It would be possible to shorten the formula by using the following syntax.

$condition.toSignal('Max').toNumber().toStep(1week).within($condition)

Note: Depending on the format of the property using toNumber() may not be necessary so it could be removed as well.

$condition.toSignal('Max').toStep(1week).within($condition) 

Hope this helps,
Teddy

[Ethan Holmgren]

This works great, thanks a lot!

Ethan