I am using the Group By feature in a Table component, the aggregation function applied to other columns is Sum.
But I'd like to use Count, Count(Distinct [field]), etc.
How do I change the aggregation function used on each column?
Thanks,
Mahesh S.
Hi @mahesh_s!
Hey! You can change the aggregation function for each column by going to its settings (just click the column in the inspector), then scroll down to the Aggregation option. You’ll see choices like Count, Count distinct, Average, and more.
This works with the Group By feature in the Table component.
Hope that helps!
1 Like
Hi @Adnan_Khalil1 - thanks for replying.
I don't see an "Aggregate" option. I tried toggling the "editable" feature.
Hello!
The "Aggegation" option will only appear after you set at least a single field as "Grouped By".
As seen in this screenshot:
This option is very useful!
Try this out and let me know!
Hi!
I have set Gender as the Grouped By field in the table. I now want to get the Count(Distinct) for ID, SUM for Revenue USD,......
But I don't see the Aggregation option in the User ID.
Am I doing something wrong here?
1 Like
That's right!
You can only see this when I set the "Group By" option inside the Table settings, not when you use the toolbar button. Remember that this button only switches on/off the option, so you can't configure the aggregation using it.
The fields will allow you to configure the aggregation only when you set a 'Group By" field within the table settings.
Try this and let me know!
2 Likes