-
You can create a formula that involves aggregated measures coming from multiple fact tables of a chasm trap.
-
Nested formulas, or formula on formula, allow you to reference a formula within another formula.
-
Formula operators allow you to apply if/then/else conditions in your formulas.
-
You can use simple number functions to perform useful percent calculations on your data
-
Date functions are useful when you want to compare data collected between two date periods.
-
If you find that you want to pass a value to the function, but it is of the wrong data type, you can convert it using a conversion formula.
-
When working with query filters, you can switch to finer-grained or coarser-grained representation of your data
-
Filters are useful for queries where the results should reflect a new, filtered value.
-
To enable business users to answer questions related to mix, contribution, share of, percentage, and total ratios, we have added the keywords "of" and "percentage of".
-
Each of the grouping functions accepts a measure and one or more optional attributes: