What is fractional count? What is percentage count? What is fractional sum?

Liggem

In the Aggregate operator I could find the aggregation functions count(fractional), count(percentage) and sum(fractional).

How do these aggregation functions work?

BalazsBarany

Hi @Liggem!

It's easy to try out what the functions do. They are similar to the display in the Statistics page in the Results view.

Just take a sample dataset like Iris from Samples and put it into the process. Connect it to Aggregate, group by the label (the species) and insert the aggregation functions.

count(fractional) returns 0.3333 for every group, as they are evenly distributed. As with count() generally, the actual values don't matter, so you can use any attribute.
count(percentage) returns 33.3333, that's just a different representation.
sum(fractional) returns the summed up values for the group, divided by the sum of everything. This will of course return different values for different attributes (unlike count).

Regards,
Balázs

BalazsBarany

Hi @Liggem!

It's easy to try out what the functions do. They are similar to the display in the Statistics page in the Results view.

Just take a sample dataset like Iris from Samples and put it into the process. Connect it to Aggregate, group by the label (the species) and insert the aggregation functions.

count(fractional) returns 0.3333 for every group, as they are evenly distributed. As with count() generally, the actual values don't matter, so you can use any attribute.
count(percentage) returns 33.3333, that's just a different representation.
sum(fractional) returns the summed up values for the group, divided by the sum of everything. This will of course return different values for different attributes (unlike count).

Regards,
Balázs