MicroStrategy ONE

Metric Editor Formula tab: Metric level property symbols

Before you begin

This topic assumes an understanding of level metrics.

The metric definition indicates the target of the metric level. All information about the metric level is placed between curly braces { } within the metric definition.

You can display additional level properties to indicate the grouping and filtering settings. See Showing level properties.

The following table defines the metric level property symbols.

Symbol

Definition

~

Report level

An attribute name

Target

Symbols placed before the target

No symbol

Grouping = Standard

!

Grouping = None

<|

Grouping = Beginning fact

>|

Grouping = Ending fact

<

Grouping = Beginning lookup

>

Grouping = Ending lookup

Symbols placed after the target

+

Filtering = Standard

*

Filtering = Absolute

%

Filtering = Ignore

No symbol

Filtering = None

Related Topics