Just wondering about a simple lookup of historic values. Would it be possible to add a THEN card that gets a value from X min/h/d ago for a specific device from insights and stores it in a tag (and maybe a tag containing the actual time resolution because of Insights data aggregation)?
Could u explain your idea a little more? You want a single point of the past? Or a timespan in the past? Like 5 days ago till 10 days ago?
No, just one (nearest) data point would be great.
The only reason I mentioned the “resolution” was because Insights aggregates data the further it goes back in time, so instead of 1 min data points you may end up with an average over 5m or 1h data intervals if it’s a long time ago.
Example: get value for Power consumption of a plug now and 24 ago and calculate the difference to get usage over last 24h.
BTW: I think there is still an issue with 1.0.5:
Regardless of the interval chosen I get the same cunsumtion for Max - Min?
These both give 9.2 kWh, but the range of 36h should have a lower min, so higher consumption than over the last 24h? Also the same for 48h.
I‘ll take a look at once I‘m home.
I‘m thinking about adding a token to the current cards with first value, last value plus there timestamp
Although just an additional THEN card might be a lot “lighter” on resources if a trend calculation is not needed…
Maybe you can find a solution here with the app " Flow Utilities".
I know there are other apps that could be used, and I could even just use variables for this specific scenario (at time X set StartValue). But I thought it would make sense for “Insight Trends” to have this option to get any data point from insights in its feature set.
I’ll add a card like this in some time in the future.
For now I added them to the current card.
Check out the latest test version
Also this is fixed
Nice! Does that also include a “Significant figures” setting by any chance?
BTW: I’ve been using the min/max for a couple of days and it works well!
Maybe
Without:
[InsightTrendsReloaded] Got 167 from getLogs. The tokens are: {
min: 53.6,
max: 68.30333333333333,
mean: 59.146218396540284,
median: 58.92527777777778,
standardDeviation: 2.2823017239060737,
trend: -0.000007057882446205948,
firstvalue: 64.44902777777777,
firstvalue_timestamp: 1667318400000,
firstvalue_time: '01/11/2022, 17:00:00',
lastvalue: 58.37375,
lastvalue_timestamp: 1667916000000,
lastvalue_time: '08/11/2022, 15:00:00',
size: 167
}
With:
[InsightTrendsReloaded] Got 167 from getLogs. The tokens are: {
min: 53.6,
max: 68.3033,
mean: 59.1462,
median: 58.9253,
standardDeviation: 2.2823,
trend: -0,
firstvalue: 64.449,
firstvalue_timestamp: 1667318400000,
firstvalue_time: '01/11/2022, 17:00:00',
lastvalue: 58.3738,
lastvalue_timestamp: 1667916000000,
lastvalue_time: '08/11/2022, 15:00:00',
size: 167
}
Test version will come out soon But its not done yet.
Edit: Just released the first test version.
It’s not the final settings page and is still work in progress.
Stuff that will come.
- A way change the precision of the significant figures
Reload button for the graph/chartMore Info Fields for the graphPercentile support- Suggestions of the community?
feature = Completed.
Best regards
Nice settings panel!
Why can I not find all my insights?
Do you find not any or just some?
It should show all of your insights
For example if I search “power” there is just 5 hits. It schould at least 25 hits.
Same problem with search for “temperature”.
Oh, i bet the default limit is 5. I‘ll change that.
I can confirm I also only see a small number of my total devices.
Should the list also populate without entering anything, or only when you start typing?
It is not just a limit problem. Some insights can not be found even if it is fewer than 5 hits.
I changed some stuff on the search engine. Please check out the latest test version.
It should show the same stuff as the flow auto complete since it has the same back-end code.
I’m currently at work so I can’t debug so good.