How to get the time duration of cumulative temperature values

Working with Data
1

Hi,
I am having a new requirement, I am having a collection and having a fields like dId, tmp, and createdOn,
my requirement is to get the cumulative tmp values which are greater than 10 for 24 hours with in last two days from the current date. For getting the last two days records from current date I am using the following aggregation

[ { $match: { createdOn: { $gte: new Date(new Date().getTime() - 22460*60 * 1000) } } } ]

For example i am having a data like
/* 1 */
{
“_id” : ObjectId(“61e67d390fcdd25fa73aa080”),
“dId” : “356849088494265”,
“tmp” : 7.0,
“createdOn” : ISODate(“2022-01-18T08:41:29.932Z”)
}

/* 2 */
{
“_id” : ObjectId(“61e67d390fcdd25fa73aa081”),
“dId” : “356849088494265”,
“tmp” : 25.9,
“createdOn” : ISODate(“2022-01-18T08:42:29.953Z”)
}

/* 3 */
{
“_id” : ObjectId(“61e67d390fcdd25fa73aa082”),
“dId” : “356849088494265”,
“tmp” : 5,
“createdOn” : ISODate(“2022-01-18T08:45:29.953Z”)
}

/* 4 */
{
“_id” : ObjectId(“61e67d390fcdd25fa73aa083”),
“dId” : “356849088494266”,
“tmp” : 26.0,
“createdOn” : ISODate(“2022-01-18T08:41:29.953Z”)
}

/* 5 */
{
“_id” : ObjectId(“61e67d470fcdd25fa73aa085”),
“dId” : “356849088494266”,
“tmp” : 12.5,
“createdOn” : ISODate(“2022-01-18T08:50:29.953Z”)
}

/* 6 */
{
“_id” : ObjectId(“61e67d470fcdd25fa73aa086”),
“dId” : “356849088494266”,
“tmp” : 25.9,
“createdOn” : ISODate(“2022-01-18T08:55:29.953Z”)
}

/* 7 */
{
“_id” : ObjectId(“61e67d470fcdd25fa73aa087”),
“dId” : “356849088494266”,
“tmp” : 7.0,
“createdOn” : ISODate(“2022-01-18T08:56:29.953Z”)
}

/* 8 */
{
“_id” : ObjectId(“61e67d470fcdd25fa73aa088”),
“dId” : “356849088494267”,
“tmp” : 26.0,
“createdOn” : ISODate(“2022-01-18T09:41:29.953Z”)

}

/* 9 */
{
“_id” : ObjectId(“61e67d530fcdd25fa73aa08a”),
“dId” : “356849088494267”,
“tmp” : 26.0,
“createdOn” : ISODate(“2022-01-18T09:55:29.953Z”)
}

/* 10 */
{
“_id” : ObjectId(“61e67d530fcdd25fa73aa08b”),
“dId” : “356849088494267”,
“tmp” : 2.0,
“createdOn” : ISODate(“2022-01-18T09:56:29.953Z”)
}

Here i am providing 3 different dId’s, which are 356849088494265, 356849088494266 and 356849088494267, and providing their tmp values and their dates, whenever tmp value changes the new record will be inserted with their tmp value, and with createdOn date with time and its device Id which is dId.

So here we can observe that for dId: 356849088494265 for record 2 the tmp value is 25.9 which is greater than 10 and its date and time is 2022-01-18T08:42:29.953Z. And In 3rd record its tmp value is 5 which is less than 10 and its date and time is 2022-01-18T08:45:29.953Z . the tmp value is greater than 10 for 8:42 to 08:45 right? i have to get that time duration.

And for dId: 356849088494266 in 4th,5th and 6th records we can observe that its tmp value is greater than 10 and its date and time starts at 2022-01-18T08:41:29.953Z and ends at 2022-01-18T08:56:29.953Z, so tmp value is grater than 10 starts at 4th record and continuously grater than for 5th and 6th and tmp values gets less at 7th record which is at 2022-01-18T08:56:29.953Z so i have to get the time duration from 08:41 to 08:56 , And i have to sum that cumulative sums of time duration which we got for each dId, and if the sum of time duration is greater than or equals to 24 hours i have to get those records. Hope get my requirement . Its little bit of tricky, But i dont have any idea on aggreaton. Hence requesting you support on this. Any help on this highly appraciated.

2

Please read Formatting code and log snippets in posts and provide your sample documents in a format that we can cut-n-paste.

3

Hi Steevej,
Greetings,

As per the suggestion, providing the sample data.

db.temperatures_cumulative.insertMany([{“_id”:ObjectId(“63fa1beeba44dd674dda511a”),“dId”:“356849088497870”,“tmp”:55.8,“createdOn”:ISODate(“2023-02-25T14:32:14.597Z”)},{“_id”:ObjectId(“63fa1beeba44dd674dda5118”),“dId”:“356849088497870”,“tmp”:6.4,“createdOn”:ISODate(“2023-02-25T14:32:14.596Z”)},{“_id”:ObjectId(“63fa1beeba44dd674dda5116”),“dId”:“356849088497870”,“tmp”:55.9,“createdOn”:ISODate(“2023-02-25T14:32:14.594Z”)},{“_id”:ObjectId(“63fa1beeba44dd674dda5114”),“dId”:“356849088497870”,“tmp”:6.4,“createdOn”:ISODate(“2023-02-25T14:32:14.593Z”)},{“_id”:ObjectId(“63fa1beeba44dd674dda5112”),“dId”:“356849088497870”,“tmp”:55.9,“createdOn”:ISODate(“2023-02-25T14:32:14.591Z”)},{“_id”:ObjectId(“63fa1beeba44dd674dda5110”),“dId”:“356849088497870”,“tmp”:6.4,“createdOn”:ISODate(“2023-02-25T14:32:14.588Z”)},{“_id”:ObjectId(“63fa1bedba44dd674dda50da”),“dId”:“865006041824062”,“tmp”:12.18,“createdOn”:ISODate(“2023-02-25T14:32:13.405Z”)},{“_id”:ObjectId(“63fa1bedba44dd674dda50d8”),“dId”:“865006041824062”,“tmp”:5.18,“createdOn”:ISODate(“2023-02-25T14:32:13.403Z”)},{“_id”:ObjectId(“63fa1bebba44dd674dda5070”),“dId”:“862818045314616”,“tmp”:13.12,“createdOn”:ISODate(“2023-02-25T14:32:11.539Z”)},{“_id”:ObjectId(“63fa1bebba44dd674dda506e”),“dId”:“862818045314616”,“tmp”:3.68,“createdOn”:ISODate(“2023-02-25T14:32:11.537Z”)},{“_id”:ObjectId(“63fa1bebba44dd674dda506c”),“dId”:“862818045314616”,“tmp”:13.12,“createdOn”:ISODate(“2023-02-25T14:32:11.536Z”)},{“_id”:ObjectId(“63fa1bebba44dd674dda506a”),“dId”:“862818045314616”,“tmp”:3.75,“createdOn”:ISODate(“2023-02-25T14:32:11.534Z”)},{“_id”:ObjectId(“63fa1bebba44dd674dda5068”),“dId”:“862818045314616”,“tmp”:13.25,“createdOn”:ISODate(“2023-02-25T14:32:11.533Z”)},{“_id”:ObjectId(“63fa1bebba44dd674dda5066”),“dId”:“862818045314616”,“tmp”:3.75,“createdOn”:ISODate(“2023-02-25T14:32:11.531Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda501a”),“dId”:“355026070101866”,“tmp”:28.1,“createdOn”:ISODate(“2023-02-25T14:32:09.918Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda5018”),“dId”:“355026070101866”,“tmp”:2.6,“createdOn”:ISODate(“2023-02-25T14:32:09.916Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda5016”),“dId”:“355026070101866”,“tmp”:28.1,“createdOn”:ISODate(“2023-02-25T14:32:09.915Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda5014”),“dId”:“355026070101866”,“tmp”:2.9,“createdOn”:ISODate(“2023-02-25T14:32:09.913Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda5012”),“dId”:“355026070101866”,“tmp”:28.1,“createdOn”:ISODate(“2023-02-25T14:32:09.912Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda5010”),“dId”:“355026070101866”,“tmp”:3.3,“createdOn”:ISODate(“2023-02-25T14:32:09.910Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda500e”),“dId”:“355026070101866”,“tmp”:28.0,“createdOn”:ISODate(“2023-02-25T14:32:09.909Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda500a”),“dId”:“355026070101866”,“tmp”:3.8,“createdOn”:ISODate(“2023-02-25T14:32:09.907Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda5008”),“dId”:“355026070101866”,“tmp”:28.0,“createdOn”:ISODate(“2023-02-25T14:32:09.906Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda5006”),“dId”:“355026070101866”,“tmp”:3.8,“createdOn”:ISODate(“2023-02-25T14:32:09.905Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda5004”),“dId”:“355026070101866”,“tmp”:28.0,“createdOn”:ISODate(“2023-02-25T14:32:09.903Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda5002”),“dId”:“355026070101866”,“tmp”:4.1,“createdOn”:ISODate(“2023-02-25T14:32:09.900Z”)},{“_id”:ObjectId(“63fa1be86d8192257e1653b6”),“dId”:“862818045314616”,“tmp”:13.12,“createdOn”:ISODate(“2023-02-25T14:32:08.154Z”)},{“_id”:ObjectId(“63fa1be86d8192257e1653b4”),“dId”:“862818045314616”,“tmp”:3.81,“createdOn”:ISODate(“2023-02-25T14:32:08.152Z”)},{“_id”:ObjectId(“63fa1be86d8192257e1653b2”),“dId”:“862818045314616”,“tmp”:13.06,“createdOn”:ISODate(“2023-02-25T14:32:08.151Z”)},{“_id”:ObjectId(“63fa1be86d8192257e1653b0”),“dId”:“862818045314616”,“tmp”:3.81,“createdOn”:ISODate(“2023-02-25T14:32:08.149Z”)},{“_id”:ObjectId(“63fa1be86d8192257e1653ae”),“dId”:“862818045314616”,“tmp”:13.18,“createdOn”:ISODate(“2023-02-25T14:32:08.148Z”)},{“_id”:ObjectId(“63fa1be86d8192257e1653ac”),“dId”:“862818045314616”,“tmp”:3.87,“createdOn”:ISODate(“2023-02-25T14:32:08.146Z”)},{“_id”:ObjectId(“63fa1be8ba44dd674dda4fb4”),“dId”:“356849088500509”,“tmp”:26.8,“createdOn”:ISODate(“2023-02-25T14:32:08.018Z”)},{“_id”:ObjectId(“63fa1be8ba44dd674dda4fb2”),“dId”:“356849088500509”,“tmp”:4.7,“createdOn”:ISODate(“2023-02-25T14:32:08.016Z”)},{“_id”:ObjectId(“63fa1be8ba44dd674dda4fb0”),“dId”:“356849088500509”,“tmp”:26.9,“createdOn”:ISODate(“2023-02-25T14:32:08.015Z”)},{“_id”:ObjectId(“63fa1be8ba44dd674dda4fae”),“dId”:“356849088500509”,“tmp”:4.9,“createdOn”:ISODate(“2023-02-25T14:32:08.014Z”)},{“_id”:ObjectId(“63fa1be8ba44dd674dda4fac”),“dId”:“356849088500509”,“tmp”:26.7,“createdOn”:ISODate(“2023-02-25T14:32:08.012Z”)},{“_id”:ObjectId(“63fa1be8ba44dd674dda4faa”),“dId”:“356849088500509”,“tmp”:5.0,“createdOn”:ISODate(“2023-02-25T14:32:08.011Z”)},{“_id”:ObjectId(“63fa1be8ba44dd674dda4fa8”),“dId”:“356849088500509”,“tmp”:26.2,“createdOn”:ISODate(“2023-02-25T14:32:08.010Z”)},{“_id”:ObjectId(“63fa1be8ba44dd674dda4fa6”),“dId”:“356849088500509”,“tmp”:5.1,“createdOn”:ISODate(“2023-02-25T14:32:08.008Z”)},{“_id”:ObjectId(“63fa1be8ba44dd674dda4fa4”),“dId”:“356849088500509”,“tmp”:26.2,“createdOn”:ISODate(“2023-02-25T14:32:08.007Z”)},{“_id”:ObjectId(“63fa1be8ba44dd674dda4fa2”),“dId”:“356849088500509”,“tmp”:5.1,“createdOn”:ISODate(“2023-02-25T14:32:08.005Z”)},{“_id”:ObjectId(“63fa1be8ba44dd674dda4fa0”),“dId”:“356849088500509”,“tmp”:25.3,“createdOn”:ISODate(“2023-02-25T14:32:08.004Z”)},{“_id”:ObjectId(“63fa1be8ba44dd674dda4f9e”),“dId”:“356849088500509”,“tmp”:5.1,“createdOn”:ISODate(“2023-02-25T14:32:08.001Z”)},{“_id”:ObjectId(“63fa1be6ed13fd701c7478bb”),“dId”:“862818041494719”,“tmp”:27.87,“createdOn”:ISODate(“2023-02-25T14:32:06.806Z”)},{“_id”:ObjectId(“63fa1be6ed13fd701c7478b9”),“dId”:“862818041494719”,“tmp”:3.37,“createdOn”:ISODate(“2023-02-25T14:32:06.804Z”)},{“_id”:ObjectId(“63fa1be66d8192257e165354”),“dId”:“865006041893653”,“tmp”:23.12,“createdOn”:ISODate(“2023-02-25T14:32:06.487Z”)},{“_id”:ObjectId(“63fa1be66d8192257e165352”),“dId”:“865006041893653”,“tmp”:5.37,“createdOn”:ISODate(“2023-02-25T14:32:06.485Z”)},{“_id”:ObjectId(“63fa1be56d8192257e16530b”),“dId”:“356849088499439”,“tmp”:31.0,“createdOn”:ISODate(“2023-02-25T14:32:05.121Z”)},{“_id”:ObjectId(“63fa1be56d8192257e165309”),“dId”:“356849088499439”,“tmp”:3.6,“createdOn”:ISODate(“2023-02-25T14:32:05.120Z”)},{“_id”:ObjectId(“63fa1deeba44dd674ddacd55”),“dId”:“869738067227335”,“tmp”:5.2,“createdOn”:ISODate(“2023-02-25T14:40:46.957Z”)},{“_id”:ObjectId(“63fa1deeba44dd674ddacd53”),“dId”:“869738067227335”,“tmp”:28.9,“createdOn”:ISODate(“2023-02-25T14:40:46.953Z”)},{“_id”:ObjectId(“63fa1deeed13fd701c74f7e5”),“dId”:“862818045355304”,“tmp”:25.75,“createdOn”:ISODate(“2023-02-25T14:40:46.872Z”)},{“_id”:ObjectId(“63fa1deeed13fd701c74f7e3”),“dId”:“862818045355304”,“tmp”:3.81,“createdOn”:ISODate(“2023-02-25T14:40:46.870Z”)},{“_id”:ObjectId(“63fa1deeed13fd701c74f7d8”),“dId”:“869738067228440”,“tmp”:3.3,“createdOn”:ISODate(“2023-02-25T14:40:46.666Z”)},{“_id”:ObjectId(“63fa1deeed13fd701c74f7d6”),“dId”:“869738067228440”,“tmp”:21.8,“createdOn”:ISODate(“2023-02-25T14:40:46.662Z”)},{“_id”:ObjectId(“63fa1deeba44dd674ddacd3f”),“dId”:“862818045338052”,“tmp”:27.81,“createdOn”:ISODate(“2023-02-25T14:40:46.557Z”)},{“_id”:ObjectId(“63fa1deeba44dd674ddacd3d”),“dId”:“862818045338052”,“tmp”:5.43,“createdOn”:ISODate(“2023-02-25T14:40:46.554Z”)},{“_id”:ObjectId(“63fa1deeed13fd701c74f7ca”),“dId”:“862818045360171”,“tmp”:34.18,“createdOn”:ISODate(“2023-02-25T14:40:46.388Z”)},{“_id”:ObjectId(“63fa1deeed13fd701c74f7c8”),“dId”:“862818045360171”,“tmp”:-19.31,“createdOn”:ISODate(“2023-02-25T14:40:46.386Z”)},{“_id”:ObjectId(“63fa1deeed13fd701c74f7bb”),“dId”:“355026070205337”,“tmp”:30.9,“createdOn”:ISODate(“2023-02-25T14:40:46.084Z”)},{“_id”:ObjectId(“63fa1deeed13fd701c74f7b9”),“dId”:“355026070205337”,“tmp”:4.5,“createdOn”:ISODate(“2023-02-25T14:40:46.082Z”)},{“_id”:ObjectId(“63fa1deeed13fd701c74f7b7”),“dId”:“355026070205337”,“tmp”:-2.6,“createdOn”:ISODate(“2023-02-25T14:40:46.081Z”)},{“_id”:ObjectId(“63fa1deeed13fd701c74f7b5”),“dId”:“355026070205337”,“tmp”:30.9,“createdOn”:ISODate(“2023-02-25T14:40:46.079Z”)},{“_id”:ObjectId(“63fa1deeed13fd701c74f7b3”),“dId”:“355026070205337”,“tmp”:4.5,“createdOn”:ISODate(“2023-02-25T14:40:46.078Z”)},{“_id”:ObjectId(“63fa1deeed13fd701c74f7b1”),“dId”:“355026070205337”,“tmp”:-2.6,“createdOn”:ISODate(“2023-02-25T14:40:46.076Z”)},{“_id”:ObjectId(“63fa1dee6d8192257e16d4d3”),“dId”:“869247048620543”,“tmp”:23.0,“createdOn”:ISODate(“2023-02-25T14:40:46.066Z”)},{“_id”:ObjectId(“63fa1dee6d8192257e16d4d1”),“dId”:“869247048620543”,“tmp”:2.06,“createdOn”:ISODate(“2023-02-25T14:40:46.064Z”)},{“_id”:ObjectId(“63fa1ded6d8192257e16d4c4”),“dId”:“869738067477484”,“tmp”:6.9,“createdOn”:ISODate(“2023-02-25T14:40:45.903Z”)},{“_id”:ObjectId(“63fa1ded6d8192257e16d4c2”),“dId”:“869738067477484”,“tmp”:20.2,“createdOn”:ISODate(“2023-02-25T14:40:45.899Z”)},{“_id”:ObjectId(“63fa1dedba44dd674ddacd17”),“dId”:“869247048620071”,“tmp”:30.0,“createdOn”:ISODate(“2023-02-25T14:40:45.769Z”)},{“_id”:ObjectId(“63fa1dedba44dd674ddacd15”),“dId”:“869247048620071”,“tmp”:5.0,“createdOn”:ISODate(“2023-02-25T14:40:45.766Z”)},{“_id”:ObjectId(“63fa1dedba44dd674ddacd0b”),“dId”:“869247048676024”,“tmp”:30.06,“createdOn”:ISODate(“2023-02-25T14:40:45.637Z”)},{“_id”:ObjectId(“63fa1dedba44dd674ddacd09”),“dId”:“869247048676024”,“tmp”:4.0,“createdOn”:ISODate(“2023-02-25T14:40:45.634Z”)},{“_id”:ObjectId(“63fa1dedba44dd674ddacd06”),“dId”:“869247047758120”,“tmp”:30.43,“createdOn”:ISODate(“2023-02-25T14:40:45.611Z”)},{“_id”:ObjectId(“63fa1dedba44dd674ddacd04”),“dId”:“869247047758120”,“tmp”:6.56,“createdOn”:ISODate(“2023-02-25T14:40:45.609Z”)},{“_id”:ObjectId(“63fa1deded13fd701c74f798”),“dId”:“355026070123555”,“tmp”:5.0,“createdOn”:ISODate(“2023-02-25T14:40:45.504Z”)},{“_id”:ObjectId(“63fa1deded13fd701c74f796”),“dId”:“355026070123555”,“tmp”:4.9,“createdOn”:ISODate(“2023-02-25T14:40:45.502Z”)},{“_id”:ObjectId(“63fa1deded13fd701c74f794”),“dId”:“355026070123555”,“tmp”:4.8,“createdOn”:ISODate(“2023-02-25T14:40:45.501Z”)},{“_id”:ObjectId(“63fa1deded13fd701c74f792”),“dId”:“355026070123555”,“tmp”:4.7,“createdOn”:ISODate(“2023-02-25T14:40:45.499Z”)},{“_id”:ObjectId(“63fa1deded13fd701c74f790”),“dId”:“355026070123555”,“tmp”:4.7,“createdOn”:ISODate(“2023-02-25T14:40:45.498Z”)},{“_id”:ObjectId(“63fa1deded13fd701c74f78e”),“dId”:“355026070123555”,“tmp”:4.6,“createdOn”:ISODate(“2023-02-25T14:40:45.495Z”)},{“_id”:ObjectId(“63fa1ded6d8192257e16d4b1”),“dId”:“356849088509302”,“tmp”:24.6,“createdOn”:ISODate(“2023-02-25T14:40:45.485Z”)},{“_id”:ObjectId(“63fa1deded13fd701c74f789”),“dId”:“869616062916385”,“tmp”:3.9,“createdOn”:ISODate(“2023-02-25T14:40:45.457Z”)},{“_id”:ObjectId(“63fa1deded13fd701c74f787”),“dId”:“869616062916385”,“tmp”:26.2,“createdOn”:ISODate(“2023-02-25T14:40:45.453Z”)},{“_id”:ObjectId(“63fa1ded6d8192257e16d4aa”),“dId”:“355026070233834”,“tmp”:3.7,“createdOn”:ISODate(“2023-02-25T14:40:45.432Z”)},{“_id”:ObjectId(“63fa1ded6d8192257e16d4a7”),“dId”:“355026070233834”,“tmp”:3.7,“createdOn”:ISODate(“2023-02-25T14:40:45.430Z”)},{“_id”:ObjectId(“63fa1ded6d8192257e16d4a5”),“dId”:“355026070233834”,“tmp”:3.7,“createdOn”:ISODate(“2023-02-25T14:40:45.429Z”)},{“_id”:ObjectId(“63fa1ded6d8192257e16d4a3”),“dId”:“355026070233834”,“tmp”:3.7,“createdOn”:ISODate(“2023-02-25T14:40:45.427Z”)},{“_id”:ObjectId(“63fa1ded6d8192257e16d4a1”),“dId”:“355026070233834”,“tmp”:3.7,“createdOn”:ISODate(“2023-02-25T14:40:45.426Z”)},{“_id”:ObjectId(“63fa1ded6d8192257e16d49f”),“dId”:“355026070233834”,“tmp”:3.7,“createdOn”:ISODate(“2023-02-25T14:40:45.422Z”)},{“_id”:ObjectId(“63fa1ded6d8192257e16d49c”),“dId”:“869247048707381”,“tmp”:31.43,“createdOn”:ISODate(“2023-02-25T14:40:45.394Z”)},{“_id”:ObjectId(“63fa1ded6d8192257e16d49a”),“dId”:“869247048707381”,“tmp”:4.62,“createdOn”:ISODate(“2023-02-25T14:40:45.392Z”)},{“_id”:ObjectId(“63fa1dedba44dd674ddaccf3”),“dId”:“862818045365063”,“tmp”:27.18,“createdOn”:ISODate(“2023-02-25T14:40:45.189Z”)},{“_id”:ObjectId(“63fa1dedba44dd674ddaccf0”),“dId”:“862818045365063”,“tmp”:4.25,“createdOn”:ISODate(“2023-02-25T14:40:45.186Z”)},{“_id”:ObjectId(“63fa1deced13fd701c74f774”),“dId”:“869738067208400”,“tmp”:-16.2,“createdOn”:ISODate(“2023-02-25T14:40:44.954Z”)},{“_id”:ObjectId(“63fa1deced13fd701c74f770”),“dId”:“869738067208400”,“tmp”:-16.1,“createdOn”:ISODate(“2023-02-25T14:40:44.952Z”)},{“_id”:ObjectId(“63fa1deced13fd701c74f76e”),“dId”:“869738067208400”,“tmp”:35.5,“createdOn”:ISODate(“2023-02-25T14:40:44.950Z”)},{“_id”:ObjectId(“63fa1deced13fd701c74f76c”),“dId”:“869738067208400”,“tmp”:35.5,“createdOn”:ISODate(“2023-02-25T14:40:44.948Z”)},{“_id”:ObjectId(“63fa1decba44dd674ddacce7”),“dId”:“862818045335017”,“tmp”:30.81,“createdOn”:ISODate(“2023-02-25T14:40:44.932Z”)}])

Note: I had provided current date data. but the requisting to get the two days data from current date.

Expecting result is

_id:ObjectId(“63fa1beeba44dd674dda511a”),
dId:“356849088497870”,
tmp:[23.0,12.0,15.0,18.0,10.0,]
createdOn:[ISODate(“2023-02-25T14:32:14.593Z”),ISODate(“2023-02-25T14:40:14.593Z”),ISODate(“2023-02-25T14:52:14.593Z”)],
cumulative_tmp_hours: 26

Thanks & Regards,
M. Ramesh.

4

It is not.

Have you try to cut-n-paste what it is displayed in the rendered page? I get syntax error when I do because the quotes are all wrong. The quotes would be find if you had follow the link I supplied and did what is written. I know you did not follow the link, since I do not see a click count like we see when the link is clicked.

5

Thanks for the update Steevej,
It is worked for me, Following is the result set after cut and paste in my shell.

mongos> db.temperatures_cumulative.insertMany([{“_id”:ObjectId(“63fa1beeba44dd674dda511a”),“dId”:“356849088497870”,“tmp”:55.8,“createdOn”:ISODate(“2023-02-25T14:32:14.597Z”)},{“_id”:ObjectId(“63fa1beeba44dd674dda5118”),“dId”:“356849088497870”,“tmp”:6.4,“createdOn”:ISODate(“2023-02-25T14:32:14.596Z”)},{“_id”:ObjectId(“63fa1beeba44dd674dda5116”),“dId”:“356849088497870”,“tmp”:55.9,“createdOn”:ISODate(“2023-02-25T14:32:14.594Z”)},{“_id”:ObjectId(“63fa1beeba44dd674dda5114”),“dId”:“356849088497870”,“tmp”:6.4,“createdOn”:ISODate(“2023-02-25T14:32:14.593Z”)},{“_id”:ObjectId(“63fa1beeba44dd674dda5112”),“dId”:“356849088497870”,“tmp”:55.9,“createdOn”:ISODate(“2023-02-25T14:32:14.591Z”)},{“_id”:ObjectId(“63fa1beeba44dd674dda5110”),“dId”:“356849088497870”,“tmp”:6.4,“createdOn”:ISODate(“2023-02-25T14:32:14.588Z”)},{“_id”:ObjectId(“63fa1bedba44dd674dda50da”),“dId”:“865006041824062”,“tmp”:12.18,“createdOn”:ISODate(“2023-02-25T14:32:13.405Z”)},{“_id”:ObjectId(“63fa1bedba44dd674dda50d8”),“dId”:“865006041824062”,“tmp”:5.18,“createdOn”:ISODate(“2023-02-25T14:32:13.403Z”)},{“_id”:ObjectId(“63fa1bebba44dd674dda5070”),“dId”:“862818045314616”,“tmp”:13.12,“createdOn”:ISODate(“2023-02-25T14:32:11.539Z”)},{“_id”:ObjectId(“63fa1bebba44dd674dda506e”),“dId”:“862818045314616”,“tmp”:3.68,“createdOn”:ISODate(“2023-02-25T14:32:11.537Z”)},{“_id”:ObjectId(“63fa1bebba44dd674dda506c”),“dId”:“862818045314616”,“tmp”:13.12,“createdOn”:ISODate(“2023-02-25T14:32:11.536Z”)},{“_id”:ObjectId(“63fa1bebba44dd674dda506a”),“dId”:“862818045314616”,“tmp”:3.75,“createdOn”:ISODate(“2023-02-25T14:32:11.534Z”)},{“_id”:ObjectId(“63fa1bebba44dd674dda5068”),“dId”:“862818045314616”,“tmp”:13.25,“createdOn”:ISODate(“2023-02-25T14:32:11.533Z”)},{“_id”:ObjectId(“63fa1bebba44dd674dda5066”),“dId”:“862818045314616”,“tmp”:3.75,“createdOn”:ISODate(“2023-02-25T14:32:11.531Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda501a”),“dId”:“355026070101866”,“tmp”:28.1,“createdOn”:ISODate(“2023-02-25T14:32:09.918Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda5018”),“dId”:“355026070101866”,“tmp”:2.6,“createdOn”:ISODate(“2023-02-25T14:32:09.916Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda5016”),“dId”:“355026070101866”,“tmp”:28.1,“createdOn”:ISODate(“2023-02-25T14:32:09.915Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda5014”),“dId”:“355026070101866”,“tmp”:2.9,“createdOn”:ISODate(“2023-02-25T14:32:09.913Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda5012”),“dId”:“355026070101866”,“tmp”:28.1,“createdOn”:ISODate(“2023-02-25T14:32:09.912Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda5010”),“dId”:“355026070101866”,“tmp”:3.3,“createdOn”:ISODate(“2023-02-25T14:32:09.910Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda500e”),“dId”:“355026070101866”,“tmp”:28.0,“createdOn”:ISODate(“2023-02-25T14:32:09.909Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda500a”),“dId”:“355026070101866”,“tmp”:3.8,“createdOn”:ISODate(“2023-02-25T14:32:09.907Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda5008”),“dId”:“355026070101866”,“tmp”:28.0,“createdOn”:ISODate(“2023-02-25T14:32:09.906Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda5006”),“dId”:“355026070101866”,“tmp”:3.8,“createdOn”:ISODate(“2023-02-25T14:32:09.905Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda5004”),“dId”:“355026070101866”,“tmp”:28.0,“createdOn”:ISODate(“2023-02-25T14:32:09.903Z”)},{“_id”:ObjectId(“63fa1be9ba44dd674dda5002”),“dId”:“355026070101866”,“tmp”:4.1,“createdOn”:ISODate(“2023-02-25T14:32:09.900Z”)},{“_id”:ObjectId(“63fa1be86d8192257e1653b6”),“dId”:“862818045314616”,“tmp”:13.12,“createdOn”:ISODate(“2023-02-25T14:32:08.154Z”)},{“_id”:ObjectId(“63fa1be86d8192257e1653b4”),“dId”:“862818045314616”,“tmp”:3.81,“createdOn”:ISODate(“2023-02-25T14:32:08.152Z”)},{“_id”:ObjectId(“63fa1be86d8192257e1653b2”),“dId”:“862818045314616”,“tmp”:13.06,“createdOn”:ISODate(“2023-02-25T14:32:08.151Z”)},{“_id”:ObjectId(“63fa1be86d8192257e1653b0”),“dId”:“862818045314616”,“tmp”:3.81,“createdOn”:ISODate(“2023-02-25T14:32:08.149Z”)},{“_id”:ObjectId(“63fa1be86d8192257e1653ae”),“dId”:“862818045314616”,“tmp”:13.18,“createdOn”:ISODate(“2023-02-25T14:32:08.148Z”)}])
{
“acknowledged” : true,
“insertedIds” : [
ObjectId(“63fa1beeba44dd674dda511a”),
ObjectId(“63fa1beeba44dd674dda5118”),
ObjectId(“63fa1beeba44dd674dda5116”),
ObjectId(“63fa1beeba44dd674dda5114”),
ObjectId(“63fa1beeba44dd674dda5112”),
ObjectId(“63fa1beeba44dd674dda5110”),
ObjectId(“63fa1bedba44dd674dda50da”),
ObjectId(“63fa1bedba44dd674dda50d8”),
ObjectId(“63fa1bebba44dd674dda5070”),
ObjectId(“63fa1bebba44dd674dda506e”),
ObjectId(“63fa1bebba44dd674dda506c”),
ObjectId(“63fa1bebba44dd674dda506a”),
ObjectId(“63fa1bebba44dd674dda5068”),
ObjectId(“63fa1bebba44dd674dda5066”),
ObjectId(“63fa1be9ba44dd674dda501a”),
ObjectId(“63fa1be9ba44dd674dda5018”),
ObjectId(“63fa1be9ba44dd674dda5016”),
ObjectId(“63fa1be9ba44dd674dda5014”),
ObjectId(“63fa1be9ba44dd674dda5012”),
ObjectId(“63fa1be9ba44dd674dda5010”),
ObjectId(“63fa1be9ba44dd674dda500e”),
ObjectId(“63fa1be9ba44dd674dda500a”),
ObjectId(“63fa1be9ba44dd674dda5008”),
ObjectId(“63fa1be9ba44dd674dda5006”),
ObjectId(“63fa1be9ba44dd674dda5004”),
ObjectId(“63fa1be9ba44dd674dda5002”),
ObjectId(“63fa1be86d8192257e1653b6”),
ObjectId(“63fa1be86d8192257e1653b4”),
ObjectId(“63fa1be86d8192257e1653b2”),
ObjectId(“63fa1be86d8192257e1653b0”),
ObjectId(“63fa1be86d8192257e1653ae”)
]
}

Please don’t be wrong at me Steevej , i have clicked the link which you have provided as follows.
Step 1: Placed my cursor on the link,
Step 2: Right Click on the link,
Step 3: After Right click i have selcted open link in new window option.

May be that is the reson i hope you are not able to view the status, if i click directly on the link might be you can see the status.

Regards,
Ramesh.

6

Then you must have missed the 2nd point of the first list that says:

You must also have missed the following part too:

Where and how do take the source of cut-n-paste operation?