Suggestion: when user selects from different fields to aggregate, hide the non-aggregated fields from the display
Hi,
sorry I am not sure how to explain this super-clearly, but:
I was thinking it would be neat to automatically hide fields which are exposed as aggregation options, but not selected, as the data displayed in these columns can be junk/misleading (they just show the value of the field for an arbitrary row of the rows being aggregated).
I am thinking especially for non-SQL aware users, but I find myself getting confused and having to remind myself...
I don't know if some people might want these columns to show an example value, or if they are clever at sorting to find a first/last/min/max value across the rows being grouped? If this is the case, maybe this "auto-hide" functionality could be a toggle in the data processor output configuration?
Tempted to have a go implementing if people think this makes sense, isn't problematic for some reason I am not seeing. :)