mongodb contional sum

Sparkling Skunk answered on January 3, 2022 Popularity 10/10 Helpfulness 4/10

answer mongodb contional sum

mongodb contional sum

Comment

db.Sentiments.aggregate(
    { $project: {
        _id: 0,
        Company: 1,
        PosSentiment: {$cond: [{$gt: ['$Sentiment', 0]}, '$Sentiment', 0]},
        NegSentiment: {$cond: [{$lt: ['$Sentiment', 0]}, '$Sentiment', 0]}
    }},
    { $group: {
        _id: "$Company",
        SumPosSentiment: {$sum: '$PosSentiment'},
        SumNegSentiment: {$sum: '$NegSentiment'}
    }});

Popularity 10/10 Helpfulness 4/10 Language whatever

Source: stackoverflow.com

Tags: sum whatever

Link to this answer
Share Copy Link

Contributed on Jan 03 2022

Sparkling Skunk

0 Answers Avg Quality 2/10

mongodb contional sum

Contents

More Related Answers

mongodb contional sum

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.