Custom Grouped Aggregation

Feature Requests
1

In a table, when grouping by columns, I can select an aggregation type such as sum, which conveniently gives me a total for that group in the "grouped row". However, if I have a column with custom calculations, ex. column c / column d, the grouped row aggregation is calculated incorrectly, no matter what type of aggregation I select. If I don't select an aggregation, nothing shows up. How do I get the grouped row to show the correct calculated aggregated total when columns are grouped?

Ex Table

Account Campaign Visitors Leads Leads / Visit
GROUPED of A 100 10 16% (Should be 10%)
A A 25 1 1/ 25 = 4%
A B 75 9 9 / 75 = 12%
3 Likes
2

Hi @fobtastic Thanks for reaching out -- I'm moving this to feature requests, since this isn't natively supported yet!

3

This would be so awesome. Another use case would be when having static category data - it show on the top parent row. In your example - if Campain had A in both rows - show it in the top row as well. Or for example, string values have the option of "Count Distinct" - if that Count Distinct is 1 - roll it up to the next level up.