Altair RISE
A program to recognize and reward our most engaged community members
Nominate Yourself Now!
Home
Discussions
Community Q&A
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?
Find more posts tagged with
AI Studio
Operators
Aggregate
Accepted answers
BalazsBaranyRM
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
All comments
BalazsBaranyRM
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
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
Groups