Finding values where the previous row's value was less than or equal.

[Cakehole]

Hello,
I’ve been trying to create a workflow that will highlight any rows that have a value that is less then or equal to the previous row’s value. I thought of using the Lag Column to add the previous rows value and then use the row filter to remove any that are greater than the previous value, but I don’t think there is a way to do that with the row filter. Am I going about this the right way?
Thanks,
Kevin

[ScottF]

You are on the right track. Just use a Rule-based Row Filter node after your Lag Column node. Let me generate a quick example.

LagColumnRuleBasedRowFilterExample.knwf (7.5 KB)

[Cakehole]

Thanks @ScottF that’s exactly what I was looking for. A WAY better solution than I came up with. I just needed to change the “>” to “>=” as if the numbers are the same, I don’t care, it’s only if it drops below the previous number. Thank you!