group gddata daily stats account name and date

group_gddata_daily_stats_account_name_and_date.js

var match = {
    'date': {
        '$gte': '2017-06-24',
        '$lte': '2017-06-30',
    }
}


var group = {
    '_id': {'account_name':'$account_name','region':'$region'},
    'fee': {'$sum': '$fee'},
    'cost': {'$sum': '$cost'},
    'system_size': {'$sum': '$system_size'},
    'user_size': {'$sum': '$user_size'},
}

var rets = db.gddata_daily_stats.aggregate(
    [
        {'$match': match},
        {'$group': group},
    ]
)
print('account_name,region,fee,cost,system_size,user_size')

db.gddata_daily_stats.aggregate([
                    {'$match': match},
                    {'$group': group},
],{ "allowDiskUse": true}).forEach(function(doc) {
	print(doc._id.account_name + ',' + doc._id.region + ',' + doc.fee + ',' + doc.cost + ',' + doc.system_size + ',' + doc.user_size)
});