-
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
-
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:
-
Alchemer Dashboard provides flexible aggregation with the group functions.
-
Cumulative formulas allow you to calculate the average, max, min, or sum of your data over time.
-
Moving formulas can be used to smooth out any irregularities in your data to easily recognize trends.