Logic Machine Forum
Trend Log Aggregate - Printable Version

+- Logic Machine Forum (https://forum.logicmachine.net)
+-- Forum: LogicMachine eco-system (https://forum.logicmachine.net/forumdisplay.php?fid=1)
+--- Forum: Visualization (https://forum.logicmachine.net/forumdisplay.php?fid=9)
+--- Thread: Trend Log Aggregate (/showthread.php?tid=1602)

Trend Log Aggregate - Kai-Roger - 19.09.2018

Hi

Can someone please give me a technical explanation of what Trend log "Aggregate function" means?

BR
Kai-Roger

RE: Trend Log Aggregate - admin - 20.09.2018

Each trend stores data for 3 periods:
1. Every minute (for the last hour)
2. Once every X minutes (X = user selectable)
3. Once per day

Data is added to the trend log once a minute. After that, data for the selected period and daily period is processed by the selected function. Previously, this was only an average value, now you can choose from: average, minimum, maximum and last value.

RE: Trend Log Aggregate - Kai-Roger - 20.09.2018

Thanks

RE: Trend Log Aggregate - JMM - 30.09.2018

Hi,

Can confirm me that a trend in 5 minutes, absolute value, maximum: Has to give the maximum value of 5 last minute

BR.

RE: Trend Log Aggregate - admin - 30.09.2018

Object value is sampled once every minute. If you want to know the absolute minimum in a specific time interval then you need an additional event script.

RE: Trend Log Aggregate - Evens - 17.01.2019

Hi, 

I have several SE powerTag`s that communicates on Modbus TCP to my LM. I have an object for each PowerTag that counts KWh. On these objects I have trend logs so I can see the KWh on a day to day basis.
My question is, what is the difference between Aggregate function Average and Maximum? Because I see that when I use Maximum the trend log is way to high.
Example: one day I used 17 KWh, on the average trend log I measured 17 KWh, but on Maximum trend log measured 142 KWh. Why is there so much difference?
 
BR Even Sundgot.

RE: Trend Log Aggregate - edgars - 18.01.2019

Hi Even,
each minute a sample of data is taking to use later in the defined resolution.
With aggregate function you are defining which sample to take. So if Maximum = during the minute you take maximum value of all datapoints.

RE: Trend Log Aggregate - Evens - 01.02.2019

(18.01.2019, 07:05)edgars Wrote: Hi Even,
each minute a sample of data is taking to use later in the defined resolution.
With aggregate function you are defining which sample to take. So if Maximum = during the minute you take maximum value of all datapoints.

Hi Edgars,
 
Thanks for the info, in my head it sounds like I should use maximum. But I can’t get it to work correctly. What am I doing wrong?
 
My setup:
In my switchboard I have approximately 20 fuses. I have placed a KWh counter on these fuses:
1x Main fuse.
1x Heating fuse.
1x Light fuse.
 
I have the readings from my power company, when I compare the main fuse to the list from the power company, it is totally wrong when I use Maximum. But when I use Average it seams correct.
 
But then again, I have some other problems. When calculating remaining KWh I take the KWh Main fuse – (KWh Heating fuse + KWh Light fuse) the result i am getting is an negative value. So, it seems to me that my readings are wrong.
 
What is the correct way to trend KWh? and how accurate is the measurement?
 
BR Even Sundgot.

RE: Trend Log Aggregate - Daniel - 04.02.2019

Hi
Use counter with negative delta and average.
BR