Calculated metric syntax
Calculated metric formulas are written in MDX syntax, but only support a small subset of MDX functions and operators. They can only operate on the existing metrics in the model, and must return a numeric value. You can do simple math operations to combine metrics, or simple comparison operations to return a given metric value when certain conditions are met.
Syntax specifics
If you are used to creating formulas in Tableau, be aware that the formulas for calculated metrics in AtScale use the unique names for dimensional hierarchies, levels, and secondary attributes, not the label/display name. The label is the name that appears in Tableau. The unique name is the name that is used for the object in queries.
For example, a single Date dimension might have two hierarchies, Date Month Hierarchy and Date Week Hierarchy, which contain the following levels.
| Date Month Hierarchy | Date Week Hierarchy |
|---|---|
| Year | Year |
| Quarter | Week |
| Month | Day |
| Day |
Although both hierarchies have levels named Year and Day, to prevent ambiguities in queries, the levels should have different unique names, as in this example.
| Level | Query Name |
|---|---|
| Date Month Hierarchy/Year | YearMonth |
| Date Month Hierarchy/Day | DayMonth |
| Date Month Hierarchy/Year | YearWeek |
| Date Month Hierarchy/Day | DayWeek |
To see the query name for a hierarchy, level, or secondary attribute, open the Edit Dimension panel for its dimension and look for the object in the Hierarchies section. The names displayed there are the unique names for each object.