Summary

This block is used to standardize a group of histories together, to be based on the same timestamp in order to do some calculation on them. Histories may came from different sources, therefore have different timestamps frequency with a value every 5 minutes or 20 minutes... If we want to do some calculations on them we need to have a common base for the timestamp, they should be all aligned.

 

Implementation

  • Drag and drop the block from the palette
  • Link the "execute" action from the "executed" topic of the previous block
  • Select the interval and the associated operator used to group data

 


Example

This block standardizes a group of histories every one hour and uses a sum operator to group data.

For example if we have two histories coming in the block

History 1History 2
TimestampValueTimestampValue
12:00 AM112:00 AM1
12:10 AM112:20 AM1
12:20 AM112:40 AM1
12:30 AM1

12:40 AM1

12:50 AM1


Both table will become

History 1History 2
TimestampValueTimestampValue
12:00 AM612:00 AM3


Properties

  • Artifacts: Artifacts created by this block
    • histories: list of histories used then by the other blocks
  • Interval: The interval to use to standardize the values. This interval will be common to every history
  • Operator: The operator used to group data. For a consumption, the sum will be appropriate, for a temperature, an average would sound better. It implies not to group consumption and temperature histories in the same strategy dealing with histories.