Ben K
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Library
Downloads
Gallery
Posts posted by Ben K
-
-
I am trying to create a condition that displays most recent 20 batches in the last month. Is there a good way to do this? I am currently using the below formula, but I get the error Uncertain Scalars cannot be used as thresholds for ScalarPredicates at 'isGreaterThanOrEqualTo', because it seems my $earliest_start is always an uncertain value.
$capsule = capsule(now() - 1month, now())
$selected = $batch_condition.toGroup($capsule,CapsuleBoundary.EnclosedBy).pick(-20)
$earliest_start = $selected.startKey()
$batch_condition.removeLongerThan(40h).keep('Start',isGreaterThanOrEqualTo($earliest_start))Is there any way I can fix this issue or get the most recent 20 batches another way?
Create condition for past N batches
in General Seeq Discussions
Posted
Thanks! Is it possible to do it in a way that does not require adjacent batches? Sometimes we switch products, so I would like to create a capsule that contains the last N batches of the same product, which may not be continuous.
I feel like there must be some way to do it with condition table formulas and top(), but I can't figure out how to convert my table back to capsules.