我有以下結(jié)構(gòu)的文檔。{ name: "John Doe", City : "OK", Prepaid: "Y"},{ name: "Jane Doe", City : "CA", Prepaid: "N"},{ name: "Jule Doe", City : "OK", Prepaid: "N"},{ name: "Jake Doe", City : "OK", Prepaid: "Y"}我想先根據(jù)城市對它進(jìn)行分組，然后再對預(yù)付費(fèi)進(jìn)行分組，并獲得每種預(yù)付費(fèi)類型的單獨(dú)計(jì)數(shù)?？雌饋砼c此類似的東西。{ City : OK Count : { "filter": prepaid, "count": { Y : 2 N: 1 } }}{ City : CA Count : { "filter": prepaid, "count": { Y : 0 N: 1 } }}我嘗試基于多個(gè)字段進(jìn)行聚合，它給了我文檔的總數(shù)而不是故障。這是我為聚合管道嘗試的內(nèi)容：db.collection.aggregate([ {$match:matchquery },{$group:{_id:{city: '$city', prepaid: '$prepaid' }, count:{$sum:1} }}])
如何在 mongo DB 中使用聚合進(jìn)行多層計(jì)數(shù)細(xì)分？
侃侃爾雅
2022-06-05 10:55:16
