-
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.
-
When working with formulas, it is useful to understand the difference between regular (or row-wise) formulas and aggregation formulas.
-
Apply conditional formatting to tables or charts to highlight values in the data.
-
Add a formula directly within a search.