Developer: | Karl's Plugins Like this plugin? Show your appreciation! |
Category: | Reporting/UI/Control Pages |
Github: | Github Repo |
Assistance: | Get help! Check the online documentation |
Plugin ID: | com.karlwachs.minMax |
Latest release: | v2022.16.27 released on Feb. 13, 2024 |
Release downloaded: | 0 times |
Requires: | Indigo v2022.1.0 or higher |
(Check the Releases tab below for older releases that may have different requirements) | |
Download latest release |
This is an indigo plugin that
tracks min/max/ave/count/CountIf1/std dev .. for devices/states and variables
for hour/lastHour/day/lastDay/last7Days/thisWeek/lastWeek/thisMonth/lastMonth
it will create variables deviceName_state_measurement in defined variable folder (setup in config)
v2022.16.27 | Requires Indigo v2022.1.0+ | Released Feb. 13, 2024 | fix error when data is a mix of number and strings, convert all strings to numbers |
Released on: | Feb. 13, 2024 |
Requires: | Indigo v2022.1.0+ |
Downloaded: | 0 times |
Download this release |
fix error when data is a mix of number and strings, convert all strings to numbers
Released on: | Feb. 8, 2024 |
Requires: | Indigo v2022.1.0+ |
Downloaded: | 2 times |
Download this release |
optimized code, reduced cpu by ~ 90% most of the cpu was used by the sql query (80%) now only once an hour, in between subscription to dev / variable changes
some grammar fixes
Released on: | Feb. 7, 2024 |
Requires: | Indigo v2022.1.0+ |
Downloaded: | 0 times |
Download this release |
Released on: | Feb. 7, 2024 |
Requires: | Indigo v2022.1.0+ |
Downloaded: | 0 times |
Download this release |
Released on: | Feb. 6, 2024 |
Requires: | Indigo v2022.1.0+ |
Downloaded: | 0 times |
Download this release |
stddev fix
Released on: | Feb. 6, 2024 |
Requires: | Indigo v2022.1.0+ |
Downloaded: | 0 times |
Download this release |
added other time bins day time, night time , last 12 hours, previuos 12 hours
fixed calculation of std deviation, the simplified formula does not work for LARGE numbers, back to general formula : sqrt(sum((xi-av)**2))/N
added simple average to measures
before it was ONLY time weighted average as some of the data is not in regular time intervals and some values are longer valid that others. ie when a state is not upated on a fixed time slot basis eg a lamp is off for 11, on for 1, off for 12 hours simple average would give (0+1+0)/3 = 1/3 time weighted average would be (011 + 11 * 0*12 )/24 = 1/24 instead of 1/3 now you have both.
some print out improvements, shows definitions of time windows and measures
Released on: | Feb. 4, 2024 |
Requires: | Indigo v2022.1.0+ |
Downloaded: | 0 times |
Download this release |
Released on: | June 30, 2022 |
Requires: | Indigo v2022.1.0+ |
Downloaded: | 0 times |
Download this release |
fixed compiler error
Released on: | June 26, 2022 |
Requires: | Indigo v2022.1.0+ |
Downloaded: | 0 times |
Download this release |
Released on: | March 30, 2022 |
Requires: | Indigo v7.0.2 thru v2022.2 |
Downloaded: | 0 times |
Download this release |
v7.12.17 | Requires Indigo v7.0.2 thru v2022.2 | Released Jan. 16, 2021 | added debug statements and clarified menues |
Released on: | Jan. 16, 2021 |
Requires: | Indigo v7.0.2 thru v2022.2 |
Downloaded: | 0 times |
Download this release |
added debug statements and clarified menues
v7.12.16 | Requires Indigo v7.0.2 thru v2022.2 | Released Jan. 13, 2021 | fixed issue that variables could not be deselected |
Released on: | Jan. 13, 2021 |
Requires: | Indigo v7.0.2 thru v2022.2 |
Downloaded: | 0 times |
Download this release |
v7.12.15 | Requires Indigo v7.0.2 thru v2022.2 | Released April 4, 2020 | fixed global name 'liteOrPsqlString' is not defined |
Released on: | April 4, 2020 |
Requires: | Indigo v7.0.2 thru v2022.2 |
Downloaded: | 0 times |
Download this release |
fixed global name 'liteOrPsqlString' is not defined made password entry *
v7.12.14 | Requires Indigo v7.0.2 thru v2022.2 | Released April 4, 2020 | added option for postgres userid and password |
Released on: | April 4, 2020 |
Requires: | Indigo v7.0.2 thru v2022.2 |
Downloaded: | 0 times |
Download this release |
added option for postgres userid and password
Released on: | Feb. 3, 2019 |
Requires: | Indigo v7.0.2 thru v2022.2 |
Downloaded: | 0 times |
Download this release |
fixed import of mylog
v7.11.11 | Requires Indigo v7.0.2 thru v2022.2 | Released Feb. 3, 2019 | fixed bug fillVariables, converted to std logging |
Released on: | Feb. 3, 2019 |
Requires: | Indigo v7.0.2 thru v2022.2 |
Downloaded: | 0 times |
Download this release |
added: changed to std logging
fixed bug fillVariables: error in Line '835' ; error='need more than 0 values to unpack'
v7.10.10 | Requires Indigo v7.0.2 thru v2022.2 | Released Dec. 11, 2018 | added measures: First / last Entry Value and Date |
Released on: | Dec. 11, 2018 |
Requires: | Indigo v7.0.2 thru v2022.2 |
Downloaded: | 0 times |
Download this release |
Released on: | Dec. 8, 2018 |
Requires: | Indigo v7.0.2 thru v2022.2 |
Downloaded: | 0 times |
Download this release |
added measures:
standard deviation "StdDev"
Start Value "Start" = first value in time bin and "End" = Last Value
all functions: "Min", "Max", "DateMin", "DateMax", "Ave", "Count", "Count1", "First"", "Last
time bins: this & last: hour, day, week, month, and last7Days
improved menu error checking - in case not all fields are set
improved formatting of menus and printouts
automatic subscription to changes in devices and variables. Will switch on/off if not needed optimized checking if data updates are needed to reduce cpu load
added option to select / de-select all 90 possible measures in memu "define tracking ..."
force refresh all data action & menu items
Released on: | Dec. 4, 2018 |
Requires: | Indigo v7.0.2 thru v2022.2 |
Downloaded: | 0 times |
Download this release |
added standard deviation measure ( devStd )
improved menu error checking
improved formatting of menus and printouts
added option to select / deselect all 72 possible measures in menu define tracking ...
Released on: | Dec. 2, 2018 |
Requires: | Indigo v7.0.2 thru v2022.2 |
Downloaded: | 0 times |
Download this release |
major rewrite of internal data structure.
added format option for ave/min/max variables eg %.1f or %.3f ... For count it is integer and dates it is string
added free format option for date strings in eg ...DateMax
%Y-%m-%d %H:%M:%S ==> 2018-02-24 15:13:40
%y-%b-%d %I%p %M:%S ==> 2018-Feb-24 3pm 13:40
set in config
added count if value > 0 measure
average is now a proper time weighted average, before it was just sum(values)/count.
if eg temperature is 0 for 1 hour and 10 for 9 hours
simple average would give 5, time weighted average = 9
==> sqllogger used to get the data only stores the changes, hence time weighted average is more proper
in most cases the difference is much smaller
now has the following measures:
BINS: "thisHour","lastHour","thisDay","lastDay","thisWeek","lastWeek","thisMonth","lastMonth","last7Days"
and for each of the above the following
functions: "Min","Max","DateMin = Date of Min","DateMax = Date of Max","Ave","Count","Count1= Count when value>0 - use for eg events = on/off types"
option to choose short name for variables - set in define tarcking of devices menu instead of s-2-TH-Leo-Outside_Temperature_thisWeek_Max eg set short name to L-O-Temp results in variable name: L-O-Temp_thisWeek_Max
in menu add device/state now shows the previously selected devices first
added time CPU tracking option (for debugging and experts), set in config
Released on: | Dec. 1, 2018 |
Requires: | Indigo v7.0.2 thru v2022.2 |
Downloaded: | 0 times |
Download this release |
Released on: | Nov. 28, 2018 |
Requires: | Indigo v7.0.2 thru v2022.2 |
Downloaded: | 0 times |
Download this release |
fixed error: File "plugin.py", line 154, in validatePrefsConfigUi
Released on: | Nov. 15, 2018 |
Requires: | Indigo v7.0.2 thru v2022.2 |
Downloaded: | 0 times |
Download this release |
added: 1. last 7 days measurement 2. separate remove menu from add menu 3. add expanded logging options 4. improved menus to indicate you need to select measurements and click on confirm
Released on: | Nov. 29, 2017 |
Requires: | Indigo v7.0.2 thru v2022.2 |
Download this release |
base release, docs see indigo site http://forums.indigodomo.com/viewtopic.php?f=188&t=15241
Indigo 6