I have created a view with table settings. I would like to display the name of the author and the total number of posts that he has created. I have used relations to get the author name but I don't see any fields related to count the number of posts.

Any suggestions?


If you are using D7 I think you will have to enable aggregation for you view, and then set the group by for you field (Content:nid for example) to Count.

  • Thanks for your reply krister. May i know how to enable aggregation? the only thing i can see in my modules page is a aggregator. – user4081 Dec 1 '11 at 10:06
  • Under /admin/structure/views/view/your_view you click the Advanced tab at the top-right and the you'll find Use Aggregation under Others. – Cyclonecode Dec 1 '11 at 10:19
  • thanks a lot!!! you have finally solved my 4 hrs battle:):) thank u so much. – user4081 Dec 1 '11 at 10:24
  • FYI: Count of nodes by type is a very similar question, and I posted a step-by-step instruction for Views with aggregation, as well as an export of such a view. – marcvangend Dec 1 '11 at 10:53
  • Wow amazing work marcvangend!!! thanks a lot for such a usefull explaination. Finally i got every thing working:) – user4081 Dec 1 '11 at 11:35

Which version of Views/Drupal are you using?

The User Stats module may work for what you need.

  • I tried this module. But i don know how to use this in views. – user4081 Dec 1 '11 at 10:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy