Sum calculation or mean calculation with condition

KNIME Analytics Platform
1

Hello,

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

2

You can use


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

5 Likes
3

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

https://hub.knime.com/knime/space/Examples/02_ETL_Data_Manipulation/02_Aggregations/06_Basic_Examples_for_Using_the_GroupBy_Node

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

2 Likes
4

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