How to create a view to count comments per user? 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.
I got it! Sharing my way ;)

What I did:


Created a view of comments of my type.
As fields, I added Author uid twice.
Set aggregation (COUNT) on the second Author uid.
Added a sort criteria for aggregated (Count) Author uid as descending.


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