top 6 internazioneli

db.parsed_data.aggregate(
{$unwind: "$Segments"}
  ,
{$match : {$and: [
    {$and: [{"Segments.From.Country":{$ne: "IT" }}, {"Segments.To.Country" : {$ne:"IT" }}]},
    {"SearchDate": { $gte: ISODate("2017-03-17T00:00:00.000+01:00"), $lte: ISODate("2017-04-17T00:00:00.000+01:00") }}]}}
    ,

    {
		$group : {_id : "$Segments.From.City" , "total" : { $sum : 1 }}//_id : "$Origin.Code"
    },



     {
	$sort : {total : -1}
     }