Metrics KPI field properties

Formula

The formula that the KPI uses to perform calculations.

Click Browse (...) to open the Select Formula dialog box to select an existing formula for this field. The formula defines the calculation to perform.

HasBudget

Indicates whether the field has a budget associated with it. If the field should have a budget value, select True. A budget sub-item appears beneath the field.

True, False

HasTarget

Indicates whether the field has a target associated with it. If the field should have a target value, select True. A target sub-item appears beneath the field.

True, False

HasTrendDirection

Indicates whether the field has a trend direction associated with it. If the field should have an additional trend direction field, select True.

A trend direction sub-item appears beneath the field to specify properties of the trend direction field.

An additional Trend Direction field appears next to the custom field in the Results grid. An arrow indicates the trend over time based on the last 5 rows. The method of calculation is simple linear regression.

True, False

Units

Any string value to use as the units in the display. Used for display purposes in AVEVA™ Production Management.

Any string value

ColumnName

The name that displays as column header in the Production Analyst results grid. 

String value

PasteInGrid

Specifies whether this field supports copy and paste functionality in Production Analyst results grid.

True, False

ShowInGrid

Specifies whether this field displays data in the results grid view of Production Analyst.

True, False

SummaryType

Defines how to aggregate multiple values of the field when displaying groups or totals in AVEVA™ Production Management.

Options:

• None - None

• Count - Counts the number of entries.

• Maximum - The maximum recorded value.

• Minimum - The minimum recorded value.

• Mean - The mean average of recorded values.

• Sum - The total of all recorded values.

• Last - The last recorded value.

For more information, see Aggregating data with fields.

None, Count, Maximum, Minimum, Mean, Sum, Last

TextClipping

This field determines whether the content of a field truncates to the left or the right direction in the Production Analyst results grid.

When text is cut off by the width of the column in the grid, specify which direction the text trails off.

Example

ClipLeft (...ProcessCell)

ClipRight (ProcessCell...)

Default, ClipLeft, ClipRight