I have a flag called Collect. (Flag is individual, and enabled on multiple content types.) The flag has an entity reference field to a content type called Bucket. When users flag nodes, they go to a form and select the bucket for the flagging in the entity reference field (field_bucket_select).
Users can view their Bucket list in a view that filters on 'current logged in user' (as well as the content type) so they see only the Buckets they created--so the view has a content author relationship.
The problem: I want this view to include a count of flaggings or flagged nodes, whichever works. There's no 'count' field for that available without a relationship, so I add the relationship for field_bucket_select.
Immediately, Buckets are listed multiple times in the view--exactly the number of times as there are flaggings related to each.
I go into the view advance settings and turn on distinct. No change.
Also, if I add the count field, the counts are odd.
I'm thinking this is not an usual need, so I'm just doing it wrong. Guidance appreciated.