Sum calculation or mean calculation with condition


How can I calculate a sum or average value if one or two conditions should be fulfilled?
For instance, I want to summarize that values, which occurred in august and in 2018. So I have one column with values, one column with month and one with year.

Thank you

You can use

node for calculation. Before calculation, use one of the row filter nodes.


You can find on the KNIME Hub some really nice examples for the groupby node. I like this one especially

If you go to the hub page it also link the videos on KNIMETV where those are explained.


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