MongoDB aggregate Query for to get a total count

Question

I am trying to find the sum of all commission per day but I don't know what should I do and the below is the mongoDB documents:

"operationData" : {
    "topUp" : {
        "topUpId" : "20160520182653940+043000001792098779520",
        "phoneNumber" : "792098779",
        "commission" : 4,
    }
}
}

{
    "_id" : 2,
    "dateTime" : ISODate("2016-06-20T13:56:53.970Z"),
    "operationData" : {
        "topUp" : {
            "topUpId" : "20160520182653940+043000001792098779520",
            "phoneNumber" : "792098779",
            "commission" : 6,
        }
    }
}

{
    "_id" : 3,
    "dateTime" : ISODate("2016-06-20T13:56:53.970Z"),
    "operationData" : {
        "topUp" : {
            "topUpId" : "20160520182653940+0430000017920987345243",
            "phoneNumber" : "792098779",
            "commission" : 5,
        }
    }
}

Possible dupe http://stackoverflow.com/questions/5168904/group-by-dates-in-mongodb — chridam, Jun 27 '16 at 09:31

score 1 · Answer 1 · answered Jun 27 '16 at 09:50

you need to use datetime operators ref here

Name Description

$dayOfYear Returns the day of the year for a date as a number between 1 and 366 (leap year).
$dayOfMonth Returns the day of the month for a date as a number between 1 and 31.
$dayOfWeek Returns the day of the week for a date as a number between 1 (Sunday) and 7 (Saturday).
$year Returns the year for a date as a number (e.g. 2014).
$month Returns the month for a date as a number between 1 (January) and 12 (December).
$week Returns the week number for a date as a number between 0 (the partial week that precedes the first Sunday of the year) and 53 (leap year).
$hour Returns the hour for a date as a number between 0 and 23.
$minute Returns the minute for a date as a number between 0 and 59.
$second Returns the seconds for a date as a number between 0 and 60 (leap seconds).
$millisecond Returns the milliseconds of a date as a number between 0 and 999.
$dateToString Returns the date as a formatted string.

So you could have this snippet

db.operationData.aggregate([{
            $group : {
                _id : {
                    dayOfYear : {
                        $dayOfYear : "$dateTime"
                    },
                    year : {
                        $year : "$dateTime"
                    }
                },
                commission : {
                    $sum : "$operationData.topUp.commission"
                }
            }
        }
    ])

MongoDB aggregate Query for to get a total count

1 Answers1