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 |