Calculate Average with Rule

KNIME Analytics Platform
1

Hi,

I have the following integer column with 376000 rows, the content looks like that:

 

I want to calculate the average including only the values <=52.  How can I do that?

2

Hi,

Row Splitter (or Filter) on value range (upper threshold 52) followed by simple average of the filtered table?A one-node solution would possibly require Java.

E

3

Hi Ergonomist,

The proposed solution is not a good option. because it filters out rows, something that should not happen because the column is not standalone, is part of a table and thus it filters rows also from the other columns.

4

SOLVED

I took a Math formula node and run the following expression:

if($DistanceWeek_purchase_1date$<=52,$DistanceWeek_purchase_1date$,"")

5

Conditional math is decidedly more elegant, I'll admit that much! Likely will not keep me from my usual table acrobatics, though. :-)

E