What is the problem or goal you're trying to solve or accomplish?
In Aggregate mode, users can hide a column on the fly with "Choose Columns" in the Interactive Table. The metrics don't re-aggregate when they do this. For example, if you group by country and city with COUNT(*) and then hide city, you get duplicate country rows with split counts instead of one total per country. Users expect the hidden dimension to roll up, so the table looks wrong.
How are you solving it currently?
They remove the column in the chart config and re-run the query. Another option is the Interactive Pivot Table (AG Grid pivot), where both fields are dimensions, and the user expands or collapses them.
What is your recommended solution?
When a dimension column is hidden in Aggregate mode, re-run the query without that column so the metrics re-aggregate. If that's not feasible, show a clear note in the UI that hiding a column only affects the display and doesn't re-aggregate the data.