Updated Articles

  1. Formula Operators

    Formula operators allow you to apply if/then/else conditions in your formulas.
  2. Percent Calculations

    You can use simple number functions to perform useful percent calculations on your data
  3. Conversion Functions

    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.
  4. Aggregate Filters

    When working with query filters, you can switch to finer-grained or coarser-grained representation of your data
  5. Filtered Aggregation Functions

    Filters are useful for queries where the results should reflect a new, filtered value.
  6. Keywords "of", "percentage of"

    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".
  7. Grouping Functions

    Each of the grouping functions accepts a measure and one or more optional attributes:
  8. Flexible Aggregation Functions

    Alchemer Dashboard provides flexible aggregation with the group functions.
  9. Cumulative Functions

    Cumulative formulas allow you to calculate the average, max, min, or sum of your data over time.
  10. Moving Functions

    Moving formulas can be used to smooth out any irregularities in your data to easily recognize trends.