AggregateCol

Top  Previous  Next

The AggregateCol is a column that will appear in the location list. It will also be available in future stages, accessible by it's name.

 

Example of a pre stage section:

 

<AggregateCol>

 <Name>Count</Name>

 <Visible>True</Visible>

 <Condition>

         <Line>True</Line>

 </Condition>

 <DisableEscaping>False</DisableEscaping>

 <Calculation>

         <Expression>

                 <Line>LocationList.FirstCount</Line>

         </Expression>

         <Type>Number</Type>

 </Calculation>

 <DisplaySettings>

         <Format>

                 <Line>AsStringF(This,"%g")</Line>

         </Format>

 </DisplaySettings>

 <Summaries>

         <Summary>

                 <Name>Avg</Name>

                 <Calculation>

                         <Expression>

                                 <Line>LocationList.Count.Mean</Line>

                         </Expression>

                         <Type>Number</Type>

                 </Calculation>

                 <DisplaySettings>

                         <Format>

                                 <Line/>

                         </Format>

                 </DisplaySettings>

         </Summary>

 </Summaries>

</AggregateCol>

 

 

 

 

XML Tag

Description

AggregateCol

The AggregateCol tag holds the information for each aggregate column. There is an AggregateCol for each column.

Name

The name of the aggregate column. This will appear as the header for the column. This will also be used in expressions (accessible by using LocationList.<Name>).

Visable

If true, the column will display in the location list. If false, the column will not appear in the location list (but will still be accessible in future stages).

Condition

The Condition tag is a boolean expression that determines if the calculation is evaluated or not.

Calculation

The Calculation tag holds the Expression and Type. There is one Calculation tag per AggregateCol tag.

Expresion

The Expression determines the value of the aggregate column.

Type

The type that the expression will result in.

DisplaySettings

Holds information for formatting and displaying this aggregate column.

Format

The expression that defines the final output of the aggregate column. The keyword "This" can be used to refer to the current AggregateCol.