Percent aggregation in GroupBy Node

KNIME Analytics Platform
1

Hi all,

I am not sure if I misunderstood the percent aggregation method in GroupBy node, but I would like to get the percentage of each row to the sum of all rows. E.g.,

Site Vol Percentage
A 3 0.3
B 7 0.7

But this is not what I get by using the Percent aggregation in GroupBy node. I attached the simple flow here, but the result is 0.5 each. Please advise what did I do wrong, thanks,

percent in GroupBy node.knwf (7.5 KB)

2

hi @yenhung1117
the percentage here is calculated as the percentage of unique element count to the total count of elements.
image

rgds

3

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