I have book content type, where i attached user entity reference fied. In which i can select user to assign the books.

How can i find list of users and its number of assigned books.


  • You can create a view for that.
    – Suresh R
    Aug 2, 2016 at 11:20
  • can you tell me the steps. Aug 2, 2016 at 11:21

1 Answer 1


Basically you need to add the entity reference field using relationship to the view. Then use aggregation to find the count.

Refer https://www.ostraining.com/blog/drupal/entity-reference-views/ on how to create view using entity reference field. To find the count, you can use aggregation. For using aggregation you can refer https://drupal.stackexchange.com/a/31542/48290.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.