I have a content type ("Interviewee") and a Media entity using the new media stuff in core (e.g. Remote Video) which have entity references back to the Interviewee entity.
I then have a view of the Interviewee content type, with a relationship to Media.
Rather than displaying multiple rows per person for each related media file, I'd just like display the total number of audio/video files linked to that content type in a column – including, this is important, a 0 for anyone who doesn't have media files - also ideally the column would be sortable.
Is this kind of basic counting of relationships possible in core / with a widely used module, without having to code a custom views field or a views sort plugin?
I've written similar plugins before, however I kind of assumed I could do it using aggregation - but I'm not getting anywhere.