Problem with getting number of nodes created by a user in a View I know this question is already asked, here is a few links How to count the node a user has created in a View? or How can I count the number of nodes submitted by the current user?

This is a very simple task but I am facing a problem. 
I'm trying to get the number of nodes of a certain content type created by a user. This is the configuration of the view:


setting Author uid as contextual filter
setting the content type in filter criteria and selecting Node ID as field
setting aggregation to yes and set the nid to use the Count Distinct aggregation
Setting the Pager to Display all items


If I don't use the aggregation this is the result:

2158
2151
2152
2153
2154
2155
2156
2157
2142
2143
2144
2145
2146
2147
2148
2149
2150
2141
2140
2139
2138
2137
2136
2127
2126
2125
2124
2123
2128
2129
2130
2131
2132
2133
2134
2135
2122

But if I use it, the result is :

8
15
14


which 8+15+14 = 37 and number of the nodes is also 37 but I wonder why it displays the 37 this way?
You should make sure that you have no sort criteria set in your view that splits your aggregation.