Formulas
Guides for Using Formulas
By Connor and 1 other2 authors10 articles
- FormulasTo provide richer insights, you can add a formula to your Trends AI search.
- Add a Formula to a ChartLearn how to add a formula directly to a chart.
- View or edit a formula in a searchLearn how to view or edit a formula.
- Aggregate formulasWhen working with formulas, it is helpful to understand the difference between regular (or row-wise) formulas and aggregation formulas.
- Cumulative functionsLearn how to use cumulative functions.
- Group aggregation functionsLearn how to use group aggregation functions, also known as pinned measures, to enhance your data analysis.
- Keywords “of”, “percentage of”
- Formula operatorsFormula operators help you perform conditional calculations within your data. By using these operators, you can apply if/then/else logic to return specific values or simple true/false results based on your…
- Nested formulasLearn how to use nested formulas with your data.
- Simple numerical calculationsYou can use standard mathematical functions to calculate numerical results within your formulas.