Node count published, unpublished and total I have been on this for a while, considering my low php knowledge. Anyway I would like a view that lists users with total number of articles created, total number of those articles that are published and total number of those articles that are not published per user. I have looked around for an answer to this and the closest I get is node view count which does not do what I need.
In my opinion this is not as simple as it sounds although it should be considering the capabilities of Drupal. 

I'll provide you with my solution (Drupal 7) which i implemented once in a site:

Create a users view in which you should do the following (in that order):


Remove any default Sort Criteria and don't add anything in that section
Add a field of "User: name" 
Add a "User: Content authored" relationship
Add a filter "Content: Type" = Article
Add filter "Content: Published" = Yes
Add a contextual filter of "User: uid"
Activate aggregation
Set aggregation settings of user name field to "Count"


Now when you type the uid of a user in the "Preview with contextual filter" field of the view you will get the number of published articles that particular user has created.

Clone that view and (in the cloned view) change the Content:Published filter to No from yes. Now you have a 2nd view that gives you the number of unpublished articles for every user.

Last install and enable Views Field View module and create the following users view (in that order):


Add a field of "User: Uid" and exclude it from display
Add a field of "User: name" 
Add a global view field. In the window that pops up choose the 1st view you created and the display you want from the "Views Settings" section (master display can be chosen if you like) and finally (and most importantly) in the "Contextual Filters field" use the [!uid] token (replacement patterns: [!uid] == User: Uid (raw)).
In the exact same way add a another global view field to "pull" the 2nd cloned view in this current view.
Recommendation: style the view as a table for trial reasons then theme as you like.
Also be careful to always have both global view fields after the user uid field in the Fields listing.


So this final view will present all the users of the site and next to each user the respective number of published and unpublished articles they have created. If you need the total number of articles then create an extra view without any Content: published filters and use it accordingly.