Using historic values of variables for calculation
Hello,
i’m recording some values in a variable which changes a lot (outside temp, current power usage of my house). To get avarage values or sums i’m currently working with rules and tons of variables.
So i’m asking myself if there is a smarter way. All values are stored in the database.
Is there a way to use these in a variable, maybe as a reg ex?
for example
@Raducanu said in Using historic values of variables for calculation:
variable which changes a lot (outside temp, current power usage of my house). To get avarage values or sums i’m currently working with rules and tons of variables.
So i’m asking myself if there is a smarter way. All values are stored in the database.
Well you could write a script which does the required SQL queries to provide the stats you need.
A plugin for this would be nice as the task can be easily generalized. I think I can create something simple based on parts of the pimatic-filter code for stats and a DB query module. It would be nice, however, if you (or someone else) can provide the necessary query statements for different scenarios.
"It always takes longer than you expect, even when you take into account Hofstadter's Law.", Hofstadter's Law
As the database is sqllite, just a “wrapper” for
https://sqlite.org/lang_aggfunc.html
would fine.
Add a third typ of variable “Aggregate”. The sytax should be contain three things:
