How to count Multiple Fields in mongo db Using Group-by with condition [duplicate]

Question

I Want to count "winStatus" 3 times by condition LOSS, Win and Pending.

gameBids.aggregate([
        { 
            $group : { 
                _id: "$userId",
                countBids           : { $sum : 1 },
                winCount            : { $sum : { $cond: { }}},
                loseCount           : { $sum : { $cond: { }}},
                pendingCount        : { $sum : { $cond: { }}},
                sumbiddingPoints    : { $sum: '$biddingPoints'},
                sumWinPoint         : { $sum: '$gameWinPoints'}
            }
        }
    ], function (error, group) {
            if (error) throw error;
            else res.json(group);
    });

how this can be done ?

coder_B · Accepted Answer · 2019-09-26 08:36:20Z

0

Add $cond in group stage as

 {$group: {
 gameBids.aggregate([
        { 
            $group : { 
                _id: "$userId",
                countBids: { $sum: 1 },
                winCount: {
                    "$sum": {
                        $cond: {
                            if: { $eq: ['$winStatus', 'Win'] }, then: 1, else: 0
                        }
                    }
                },               
                loseCount: {
                    "$sum": {
                        $cond: {
                            if: { $eq: ['$winStatus', 'Loss'] }, then: 1, else: 0
                        }
                    }
                },
                pendingCount: {
                    "$sum": {
                        $cond: {
                            if: { $eq: ['$winStatus', 'Pending'] }, then: 1, else: 0
                        }
                    }
                },
                sumbiddingPoints:    { $sum: '$biddingPoints' },
                sumWinPoint         : { $sum: '$gameWinPoints'}
            }
        }
    ], function (error, group) {
            if (error) throw error;
            else res.json(group);
    });

edited Sep 26, 2019 at 8:36

coder_B

1102 silver badges11 bronze badges

answered Sep 26, 2019 at 8:03

sushant mehta

1,2841 gold badge7 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

coder_B Over a year ago

giving error "MongoError: unknown group operator '$cond'"

kRiZ Over a year ago

Add $sum before $cond. You will get the correct result. "winCount": { "$sum": { "$cond": { "$eq": [ "$winStatus", "$Win" ] }, 1, 0 } },

coder_B Over a year ago

winCount: { "$sum": { $cond: { if: { $eq: ['$winStatus', 'Win'] }, then: 1, else: 0 } } }, this gave me result thank you :)

Collectives™ on Stack Overflow

How to count Multiple Fields in mongo db Using Group-by with condition [duplicate]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related