Hello,
If you want to show multiple temperatures in the same line chart widget, you can use a thing service where you get all of your temperatures and put them all in the same infotable.
Start with creating a data shape containing a date and your temperatures.
Something like this:
Then in your service you would first have to use the QueryPropertyHistory function for each of your properties.
Once you have them you would have to map your history values to the new infotable.
Here is some example code how you could do it, however I need to point out that if you have a lot of history data, this is not optimal as we are looping a lot.
// CreateInfoTableFromDataShape(infoTableName:STRING("InfoTable"), dataShapeName:STRING):INFOTABLE(TestDateTimeTemp)
let datetimetemp = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({
infoTableName: "InfoTable",
dataShapeName: "TestDateTimeTemp",
});
const temp = me.DateTimeTempTest;
const temp2 = me.DateTimeTempTest2;
// TestDateTimeTemp entry object
temp.rows.toArray().forEach((temperature) => {
let newEntry = {
Date: temperature.Date, // DATETIME
Temp: temperature.Temp, // NUMBER
};
datetimetemp.AddRow(newEntry);
});
temp2.rows.toArray().forEach((temperature) => {
let newEntry = {
Date: temperature.Date, // DATETIME
Temp2: temperature.Temp2, // NUMBER
};
datetimetemp.AddRow(newEntry);
});
result = datetimetemp;
The code basically just creates an empty infotable using the data shape we created earlier and fetches two properties (with dates and temperatures in them). You would use the QueryPropertyHistory instead.
And then we loop though each of these properties (history) and adds each row to the infotable that will contain all values.
You can then use this infotable as your output and connect it to your line chart like this:
Where "UnionTest" would be the name of your service and:
The XAxisField is set to your date.
This should give you something like this:
Obviously it would look a bit different for you. But in general it should work like this.
I'm not quite sure what your issue is with the date time though... Where are you getting this 01/01/1970 date?
Regards,
Jens
