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

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?

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)


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!

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.