Wheel Statistics

wheelStatics.js

db.getCollection("wheel_histories").aggregate(
    [
        {
            "$match" : {

            }
        }, 
        {
            "$group" : {
                "_id" : "$createdAtInt",
                "totalGem" : {
                    "$sum" : "$receivedItem.value"
                },
                "totalSpin" : {
                    "$sum" : NumberInt(1)
                },
                "users" : {
                    "$addToSet" : "$user"
                }
            }
        }, 
        {
            "$project" : {
                "totalGem" : "$totalGem",
                "date" : "$_id",
                "totalUser" : {
                    "$size" : "$users"
                },
                "totalSpin" : "$totalSpin"
            }
        }, 
        {
            "$sort" : {
                "date" : NumberInt(1)
            }
        }
    ], 
    {
        "allowDiskUse" : false
    }
);