Get historic variable value

[Sander_Arends]

How is it possible to get the historic value of a variable in HomeyScript?

I have a numeric variable and I want to know what its value was two weeks ago.

I can see the value in the graphs of insights but I cannot reproduce the value in HomeyScript.

[Eko_taas]

Was happy to find this existing Q, but still unlucky to find it with zero replies.

Currently (with my newbee knowledge) if I want to adjust some control parameters based on historical data, I need to export those from Insights-data with suitable time scale to get ready made e.g. daily averages (one-by-one only).

Obviously building counters / collecting separate JSON would also be possible, but feels bit stupid when data exists already…

If other ways to do it, hints appreciated

[Dijker]

[APP][Pro] Insight Trends Reloaded

Insight Trends With the help of Homey’s insightful features, you can view all sensor measurements and their historical evolution. Take it a step further and do more than just observe the insights; act accordingly or even glimpse the future a little. [xlarge] You can choose an insight (a device and a capacity, such as the outside temperature), as well as a timeframe to analyze. The outcomes will then be computed as follows: Trend a number between -1 and 1 that indicates whether the sensors’…

[Peter_Kawa]

With a little D-tour:
The Device Capabilities app has the perfect flowcard, and you can emulate it in Hscript

Explained:

You can emulate most AND & THEN flowcards in Homeyscript.
Check example-flowcard-run on how to do that.
Now, when you haven’t already, install Device Capabilities app first
When you run example-flowcard-list it will return all And & Then cards available on your Homey → you can search for the Device Capabilities card ‘Then’ ‘Retrieve the insights value from’
(this script can take quite a while to finish, remove the ‘And’ part in order to show the ‘Then’ part results way more quicker)

[Eko_taas]

Thanks for fast and very relevant hints!

As my main interest (at this point) is some average values (e.g. outside temperature in last 7 days), “Insight Trends Reloaded” seems 1st app to start.

[Eko_taas]

After finalized other part of coding, and finally realized what you tried to propose

I looked at flowcard emulation examples, but seems that still cannot get agrs right.

e.g. flowcard (same trouble with Device Cap app emulation)

Calculate trend for [[insight]] based on the last [[range]] [[unit]]
{
“id”: “homey:app:com.spkes.insightTrendsReloaded:calculateTrendWithoutToken”,
“args”: [
{
“type”: “autocomplete”,
“name”: “insight”,
“title”: “Insight”,
“placeholder”: null
},
{
“type”: “number”,
“name”: “range”,
“title”: “Time range”,
“min”: 1,
“value”: 15,
“placeholder”: null
},
{
“type”: “dropdown”,
“name”: “unit”,
“title”: “Time unit”,
“values”: [
{
“id”: “1”,
“title”: “Minutes”
},
{
“id”: “60”,
“title”: “Hours”
},
{
“id”: “1440”,
“title”: “Days”
}
],
“placeholder”: null
}
],
“droptoken”: null,
“duration”: false
}

Would like to emulate this card:

where sensor data in Insights:

result = await Homey.flow.runFlowCardAction({
uri: ‘homey:app:com.spkes.insightTrendsReloaded’,
id: ‘homey:app:com.spkes.insightTrendsReloaded:calculateTrendWithoutToken’,
args: {
insight: ‘XXXXXXXXX-467d-47ad-845d-0b248f66bf3a.measure_temperature’,
range: 1,
unit: 1440,},
});

log (result);

or others like

insight: ‘Eteinen Lämpö.Temperature °C’,
insight: ‘Eteinen Lämpö.Temperature’,

with same error:

Error: Timed out after 30000ms.

Any advice how to figure out what should I put in or where to look for?

[Eko_taas]

@Eko_taas

Calculate trend for [[insight]] based on the last [[range]] [[unit]]

Now realized that on sensor I can see

insight: ‘homey:device:XXXXXX-467d-47ad-845d-0b248f66bf3a:measure_temperature’

even if changing to that still not working

[pbruining]

@Peter_Kawa

Device Capabilities app

I had the same question, but i managed to do it in a HomeyScript without using any additional flows or Apps.

Eventually i needed an average and wrote this function to obtain it:

async function calculateLastHourAverage(deviceId, capabilityId) {
  
  const logId = `homey:device:${deviceId}:${capabilityId}`;
  const logData = await Homey.insights.getLogEntries({
    id: logId,
    resolution: 'lastHour'
  });

  let total = 0;
  for (const value of logData.values) {
    total += value.v;
  }
  
  return total / logData.values.length;
}


// Usage

const weatherStationDeviceId = '9a2053b8-a961-4d25-82c7-808ae82af2aa';
const windspeedCapabilityId = 'measure_wind_strength';

const averageWindspeed = await calculateLastHourAverage(weatherStationDevice.id, windspeedCapabilityId);

I know it’s a bit late, but it may help you or others