Aggregate Formulas

When working with formulas, it is useful to understand the difference between regular (or row-wise) formulas and aggregation formulas.

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

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

Alchemer Dashboard provides flexible aggregation with the group functions.

Each of the grouping functions accepts a measure and one or more optional attributes:

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

Filters are useful for queries where the results should reflect a new, filtered value.

When working with query filters, you can switch to finer-grained or coarser-grained representation of 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.

Date functions are useful when you want to compare data collected between two date periods.

You can use simple number functions to perform useful percent calculations on your data

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

Nested formulas, or formula on formula, allow you to reference a formula within another formula.

You can create a formula that involves aggregated measures coming from multiple fact tables of a chasm trap.