2

I have a collection in mongo, and its data is;

[
    {
        "_id": "AAAAA",
        "date": "17-01-2020",
        "query": {
            "user_overview":{ "total": 5, "view": 15},
            "device":[
                { "name": "Samsung", "value": 3 },
                { "name": "Huawei", "value": 2 },
            ]
        }
    },
    {
        "_id": "BBBBB",
        "date": "18-01-2020",
        "query": {
            "user_overview":{ "total": 2, "view": 8 },
            "device":[
                { "name": "IPhone", "value": 4 },
                { "name": "Samsung", "value": 1},
            ]
        }
    },

    ... # goes like this 

]

What i want to do is sum and merge day by day on same month and create monthly data like below

[
    {
        "_id": "------",
        "date": "31-01-2020",
        "query": {
            "user_overview":{ "total": 133, "view": 399 },
            "device":[
                { "name": "Samsung", "value": 32 },
                { "name": "Huawei", "value": 49 },
                { "name": "IPhone", "value": 24 },
            ]
        }
    },
    {
        "_id": "------",
        "date": "29-02-2020",
        "query": {
            "user_overview":{ "total": 534, "view": 348 },
            "device":[
                { "name": "Samsung", "value": 78 },
                { "name": "Huawei", "value": 44 },
                { "name": "IPhone", "value": 19 },
            ]
        }
    }
]

I made some research on it, but couldn't find any useful information. Any comment will be helpful for me.

ozcanyarimdunya
  • 2,324
  • 1
  • 18
  • 21

0 Answers0