Use Smart Columns in Aggregation Facts
Good news, in MooD 17 users can now use cached and uncached smart columns inside aggregation facts, allowing the reuse of business logic.
Use Smart Columns in Aggregation Levels
This means complex logic can be used to produce aggregation levels, e.g., histograms, or first letter of a pick item name.
They can also be used in the axis or series of new charts.
Addition of BETWEEN, AND, and OR to Function Facts
Upon feedback from users, we have added a BETWEEN Function Fact to allow users to make a comparison easily, without the need to use both "IS GREATER THAN" and "IS LESS THAN" in a fact.
Please Note: that the Between function is inclusive of the start and end values; for example, if you say between 1 and 10, then values of 1 and values of 10 will be included in the results.
In addition, we have also added AND and OR conditions to make it easier to test for multiple conditions.