Formulas are an essential feature of Tonkean. They enable you to use data from any of the Data Columns you have configured to give you insightful information about all of the data Tonkean is tracking.
You can write more expressive mathematical formulas that enable a deeper, more complex analysis of data in your Lists. This article provides details on what the various terms relative to Formulas mean, and a detailed explanation on each of the mathematical expressions available in Tonkean.
Creating a Formula
There are two ways to create a formula. One way is from within the Module itself.
-
Click on Fields on the workflow Module
-
On the left pane that pops up, click on [+] Add Field next to the custom fields
-
Select the Formula option
The second way is from the Live Report.
-
On the far right of your Live Report, click on the green [+] button
-
Select Create a Formula
-
Select Other…
-
Select the Formula option
There are two different types of options when creating a formula:
BASIC = This is simply a roll-up using one of the predefined formulas within Tonkean. Select the calculation, and the specific row (if any) you want to calculate from and you’ll get a preview to the right
ADVANCED = When you need to combine two or more columns together, concatenate fields, do more complex formulas, or extract specific text from a dataset. There are many built-in formulas within Tonkean that you can leverage, on top of customizing them even further to your desired results. Your entire formula should be typed in the text box below the Formula Editor label and you’ll see a preview of your Key Metric output to the right.
Variables
All Data Columns (but not Key Metrics) can be used as formula variables. They must be represented in this format, {Column Name}, in order to function properly.
For example, a sum of two columns: {A} + {B}
{A} and {B} are the names of the Data Columns.
Functions and formulas can use a column as a variable or constant value in any combination:{B} / {A} * 100
Formula Type
Tonkean determines the output of formulas based on the formula type. There are two formula types.
Calculated Value
A formula calculates a value based on data from two or more columns.{A} + {B} creates a total that Tonkean outputs as a number.
Statement Validation
A formula determines a True/False (Boolean) answer based on comparing a calculation against another column's constant value.({A} + {B}) / 2 = {C}, returns True or False.
Functions
All function arguments can be constants, variables and/or formulas. For example, all of these are valid:
Max(1, 2)
Max(1, {A}, 3)
Max(1, {A}, 3, 4 + 5, {A} + Max(1, 5) + {B} + {C} ^ {D})
({A} + {B} + 1 = 3) AND ({A} - {C} * {D} = Max(1, 2))
Comments