Metric Editor Formula tab: Identifiers and delimiters

Before you begin

This topic assumes an understanding of level metrics, conditional metrics, and transformation metrics.

The various components of a metric definition are color-coded to help you easily recognize and identify them. Each component also has a set of unique delimiters that clearly show where each component begins and where it ends.

The following table lists the metric components, their format, default values, and default colors.

Component	Expression	Default Value	Default Color
Name	Name of the metric (Blank if the metric is not yet named)	None	Bold black
Aggregation type	[object name]	{aggr. level} varies by object type; see Note below	Black
Formula aggregation	[aggr. unit]	None	Dark blue
Level (Dimensionality)	Aggregation level	Report	Gray
Conditions	|filter name|	|nothing| (that is, an empty filter)	Green
Transformation	Attribute being transformed	|nothing| (that is, no transformation)	Light blue

The default function for a metric aggregation depends on the object selected for calculation. For example, Sum is the default function for a fact aggregation while Count is the default function for an attribute aggregation.

Delimiters

The table shows the delimiter used for each component in a metric definition.

Delimiter	Definition
[ ]	Object name
{ }	Level (dimensionality)
< >	Conditionality
| |	Transformation
" "	String
' '	Date

 

See also Metric Editor Formula tab: Metric level property symbols.

Related Topics

• About level metrics

• About conditional metrics

• Creating transformation metrics

• Creating metrics

• Creating simple metrics

• Creating compound metrics

• Metric Editor Formula tab: Metric definition

• Metric Editor Formula tab: Formula definition

• Metric Editor Formula tab: Level definition

• Metric Editor Formula tab: Condition definition

• Metric Editor Formula tab: Transformation definition