I need to create a table of users in views.
The user entity has a field: field_reports
This is an entity reference field. It references a custom entity "reports".
field_reports is a multi value field. Each user has three reports.
I need to display information from the individual reports in the table.
Here is an example of columns I’m trying to display:
uid | name | report one score | report two score | report three score
The "score" in each report is an integer field in the report entity (field_score)
Is this possible in views. Or is there a D9 compatible module that can achieve this?
For example, is it possible to add three separate relationships, each relationship is a specific "delta" of field_reports
Or when I add the a field_score (using a field_reports relationship), is it possible to specify which delta of the field_reports relationship to use?