Wednesday, August 21, 2013

Level Metric Formulas

When creating a level metric on the fly (Derived metric inside a report), there is some syntax you need to know for the different grouping and filtering options.
The table bellow shows the different options:



Metric Level target
~ Report Level
[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

The above means that, if you need to create a dynamic level metric, it would look like this:
Sum([Metric]) {~}
Sum([Metric]) {[Year]}
Sum([Metric]) {![Year]*}

I got these definitions from Raja Vel on his blog:


  1. All slots 카지노사이트 are primarily based on one key thought – spin the reels and hope they land on a certain mixture. This makes understanding slot games extremely easy for a newbie, as when you perceive how one performs out, you know the fundamentals behind all of them. The code beneath simulates your net achieve should you guess $1 on purple on 400 completely different spins of the roulette wheel. The app from Wild Casino is great for a number of|numerous|a selection of} completely different devices.