Wählen Sie in der gleichen mongodb-Abfrage Gruppierung nach Anzahl und eindeutiger Anzahl aus

Ich versuche, etwas zu tun, wie

select campaign_id,campaign_name,count(subscriber_id),count(distinct subscriber_id)
group by campaign_id,campaign_name from campaigns;

Diese Abfrage, indem Ergebnisse außer count(distinct subscriber_id)

db.campaigns.aggregate([
    {$match: {subscriber_id: {$ne: null}}},
    {$group: { 
        _id: {campaign_id: "$campaign_id",campaign_name: "$campaign_name"},
        count: {$sum: 1}
    }}
])

Diese folgende Abfrage, indem Ergebnisse außer count(subscriber_id)

db.campaigns_logs.aggregate([
    {$match : {subscriber_id: {$ne: null}}},
    {$group : { _id: {campaign_id: "$campaign_id",campaign_name: "$campaign_name",subscriber_id: "$subscriber_id"}}},
    {$group : { _id: {campaign_id: "$campaign_id",campaign_name: "$campaign_name"}, 
                count: {$sum: 1}
              }}
])

aber ich will count(subscriber_id),count(distinct subscriber_id) das gleiche Ergebnis

InformationsquelleAutor der Frage Rams | 2014-07-15

Schreibe einen Kommentar