Feedback about sheet bottom aggregator view

[frosencrantz]

Hi @saulpw,

Sorry this feedback took so long to send, I had meant to send this for a while. I want to thank you for adding the aggregator view to sheets. I use it regularly, it is useful!

I have some suggestions for potential improvements and feature additions:

UI Issues:

• In wide sheets, the aggregator row labels become hidden. Could these labels be repositioned under columns without aggregators, utilizing the empty space?
• For some aggregations, the whole-sheet values are not very useful, they are only relevant in the frequency sheet view. It might be useful to be able hide some of the rows.

Interaction Ideas:

• Consider enabling an aggregator on a column by clicking the empty space where it would appear, if it has already been enabled on other column(s).
• This empty space could potentially serve dual purposes - showing labels for wide sheets and acting as an activation button

Feature Requests:

1. I'd love to see an extension of the distinct aggregation that shows the most common values, like a mini frequency sheet view inline. This could be particularly useful for categorical columns, showing value counts sorted by frequency. Clicking on a value in this area could include:

• Drilling down into specific values like the frequency sheet.
• Selecting rows with that value in the current sheet.
• Quick navigation between occurrences in the current sheet.

2. Show aggregate values on the ColumnsSheet. The ColumnsSheet already shows the values for the current row, it might be useful if it could also show the computed aggregates.

Hopefully this is helpful feedback or starts conversations about what might be done next.

Edited: Changed formatting for headers, and added an additional feature request to show aggregates on ColumnsSheet.