Always had issues with Views aggregation; but this is a new one.
This is a "Group content" view; doubt that it matters.
I have a view which is a list of users in groups. It therefore requires a relationship to "Group content user". I list the Group names (table grouped on this); and within each group i list the user's name and the roles they are in. Easy enough, this works as expected. I was trying to figure out a way to have the 1 user in that group that has an extra role stick at the top of each group (i.e. the group's coordinator). I have added aggregation and then a sort on count(roles). This also works as expected. Great.
But, later i needed to add a class to the roles field. When i edit the field i see that the Relationship selector is now missing. Only on this field though. All other fields still have the relationship selector. If i save the role field it now shows as empty in my results (which makes sense as i have now saved it without the required relationship).
The only way to fix this is to disable aggregation and then go back and re-save the role field (which now has the relationship selector).
Using just core:
Active
10.1 ✨
Last updated
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
Tested on 10.1.x and can confirm this is still an issue. Updated steps to reproduce.
Can confirm the issue on 10.2
Actually the roles field doesn't even appear as an option.
My use case: I wanted to create a view reporting the number of users for each role. However, when I enable aggregation I cannot see the Roles field available to be added.