Group By: add straightforward possiblility to do aggregations over all records

[wvdvegte]

What's your use case?
What's your proposed solution?
Sometimes it is useful to have several aggregations of selected variables over all the data records. To that end, it would be nice to have "all rows" as an option in the column on the left in the Group-by interface

Are there any alternative solutions?
The obvious trick to achieve this with the current functionality is to introduce a dummy variable that has the same value for all rows, and to group by the dummy variable. However, as a workaround it is not that intuitive.

[janezd]

We had quite a discussion at today's live meeting.

Arguments against were that this is not something commonly used and it doesn't belong to Group by because it's about aggregation not grouping. On the other hand, everything is already in the widget.

We could have an option "All rows", but it would sound wrong - how do you group by all rows?

We found a compromise solution. Currently you can select multiple variables, but you have to select at least one. We can allow to deselect all variables and therefore "group by nothing" (= not group).

[wvdvegte]

That could be a solution albeit not a very intuitive one.

[janezd]

I know. We had this in mind. On the other hand, it's not intuitive to use the Group By widget to aggregate over all data, so our reasoning was that if anybody actually uses this widget for that purpose, he'll get this idea precisely by seeing that he can "group by nothing".