Create a TransposeSummarize or vTransposeSummarize function
- Last UpdatedFeb 10, 2023
- 1 minute read
- PI System
- PI SQL Commander Lite 2021
- Developer
You use the TransposeSummarize or vTransposeSummarize function if you want to apply calculations on the attributes of your function. The Calculation Basis and the Summary Type field must be selected during the function definition. Without a selection in those fields, the creation of the transpose function cannot be proceeded.
The following image shows a TransposeSummarize function with the attribute Fuel which has the calculation basis set to EventWeighted and the summary type to Average.
Only attributes with underlying numerical data types such as integer or double will provide a reasonable function result. Check the data type in the PI System Explorer.
The column name is created from the attribute name and the summary type. To change the column name, type the new name in the respective field.
In the PI System Explorer help or the AF SDK help, see AFCalculationBasis Enumeration for information about the calculation basis and AFSummaryTypes Enumeration for information about the summary type.