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

Liggem
Liggem New Altair Community Member
edited November 5 in Community Q&A
In the Aggregate operator I could find the aggregation functions count(fractional), count(percentage) and sum(fractional).
How do these aggregation functions work?

Tagged:

Best Answer

  • BalazsBaranyRM
    BalazsBaranyRM New Altair Community Member
    Answer ✓
    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

Answers

  • BalazsBaranyRM
    BalazsBaranyRM New Altair Community Member
    Answer ✓
    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

Categories