MongoDb groupby count query

Asked Jun 22 '18 at 05:42

Active Jun 22 '18 at 05:54

Viewed 67 times

I have a mongoDB document having certain columns like Id, EmployeeID, SiteID, EmployeeAddress. A employee can be present at a site more than once. I want to have a group by query along with count which will give result set as

EmployeeID SiteID Count EmployeeAddress

basically how many times an employee is present as a site. I am using this query but not getting the desired data.

  db.pnr_dashboard.aggregate(
[
{ 
    "$group" : {
        "_id" : { "siteId" : "$siteId" , "employeeId" : "$employeeId"} , 
        "count" : { "$sum":1}},


} 
]
);

edited Jun 22 '18 at 05:54

asked Jun 22 '18 at 05:42

Sarthak Jain

Could you show sample document from `pnr_dashboard` collection ? – mickl Jun 22 '18 at 05:47
@mickl sample document attached – Sarthak Jain Jun 22 '18 at 05:55
Thanks. There is not `employeeId` in your doc but you're trying to group by that field. Is that ok ? – mickl Jun 22 '18 at 05:59
EmployeeId is there but as some records do not have the employee id so in the JSON it is not present – Sarthak Jain Jun 22 '18 at 06:11
put your sample collection instead of screen shots and your query seems to be ok – Ashh Jun 22 '18 at 09:56

MongoDb groupby count query

0 Answers0