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.