I am trying to create a view with a table that shows all the users and the total number of comments that user posted in descending order. I am not sure what I am doing wrong but I spent hours on this already...

Can anybody point me to the right direction?

The closest I got is I created a view of comments so far with the author name that I tried to aggregate. But I am getting all sorts of weird results.

  • Without knowing what you did so far we can't tell you what you are doing wrong...
    – leymannx
    Dec 9, 2018 at 16:51
  • @leymannx Thank you for your quick reply. I got it working after all. I appreciate your willingness to help :) Thanks
    – ventura
    Dec 9, 2018 at 19:39

1 Answer 1


I got it! Sharing my way ;)

What I did:

  1. Created a view of comments of my type.

  2. As fields, I added Author uid twice.

  3. Set aggregation (COUNT) on the second Author uid.

  4. Added a sort criteria for aggregated (Count) Author uid as descending.

woala... Wasn't that hard after all :)

  • This is not working for me. If I compare counts vs a comment view searching by uid, the totals are quite different.
    – aharown07
    Sep 18, 2022 at 23:55

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.