Aggregate formula migration mapping details
- Last UpdatedJan 25, 2024
- 1 minute read
Limitations for migrating aggregate formulas
-
Only Min, Max, Avg, and Sum calculation types can be migrated.
-
Single Value option for aggregate formulas is not supported for migration.
wwAggregate
wwAggregate =wwAggregate( DataSource, TagRange, RowOrRes, Time1, Time2, AggCalc,ValueCriteria, OptionRange )
Equivalent formula in the Excel add-in: HISTORIAN.PERIODIC(TagList, StartTime, EndTime, Interval, Details, Down, Ascending, UOMAddress, SliceBy)
Details: Average, Minimum, Maximum, Total, Count, Last, StartDateTime, EndDateTime, OpcQuality, PercentGood and Unit.
|
Historian Client Workbook |
Excel Add-in |
|---|---|
|
DataSource As String, _ |
NA |
|
TagRange As Range, _ |
TagList |
|
rowOrRes As String, _ |
NA |
|
time1 As Variant, _ |
StartTime, |
|
time2 As Variant, _ |
EndTime, |
|
AggCalc As String, _ |
Details, |
|
Optional ValueCriteria, _ |
NA |
|
Optional OptionRange |
NA |
wwAggregateWide
wwAggregateWide =wwAggregateWide( DataSource, TagRange, RowOrRes, Time1, Time2, AggCalc, TagCriteria, OptionRange )
Equivalent formula in the Excel add-in: HISTORIAN.PERIODIC(TagList, StartTime, EndTime, Interval, Details, Down, Ascending, UOMAddress, SliceBy)
Details: Average, Minimum, Maximum, Total, Count, Last, StartDateTime, EndDateTime, OpcQuality, PercentGood and Unit.
|
Historian Client Workbook |
Excel Add-in |
|---|---|
|
DataSource As String, _ |
NA |
|
TagRange As Range, _ |
TagList |
|
rowOrRes As String, _ |
NA |
|
time1 As Variant, _ |
StartTime, |
|
time2 As Variant, _ |
EndTime, |
|
AggCalc As String, _ |
Details, |
|
Optional ValueCriteria, _ |
NA |
|
Optional OptionRange |
NA |