What is the Add Calculated Field Function?
The dashboard is equipped with the Add Calculated Field function. Existing fields can be recalculated to obtain fields through calculated fields.
Charts that allow adding calculated fields are:
Detail Table
Stats
The calculated result is a numeric value.
When to Use it?
Calculated fields are mainly used to make up for some statistical data not entered in form fields. For example:
The scores of each subject are entered in Student Score, but the total score is not entered. By adding a calculation field, the total score can be displayed on the dashboard.
Sales and gross profit are recorded in the chart Sales Data, but the gross profit rate is not entered. By adding a calculation field, the gross profit rate can be displayed on the dashboard.
Use Conditions
Condition | Description |
Charts that support adding calculated fields | Stats and Detail Table |
Calculated fields supported by detail tables | Detail Table: support addition (+), subtraction (-), multiplication (*), and division (/). |
Supported Function Formulas | Detail Table: support addition (+), subtraction (-), multiplication (*), and division (/).
|
What does it Look Like?
The total score is calculated by the added calculated field as follows:
How to Set up?
Step 1 Importing Data
Select an app and click New > New Form > Create from Excel.
Import the Excel Student Score:
Field types are as follows. Click Import to import the data:
Step 2 Creating a Dashboard
After importing the data, create a dashboard:
Step 3 Adding a Chart
Rename the created dashboard, add a detail table, and select the imported form as the data source.
Step 4 Adding Calculated Fields
Rename the chart and click to add a calculated field:
The calculated field consists of a field name, formula, and available variables.
Element of a Calculated Field | Description |
Field name | The user can customize the field name, with a maximum of 100 characters. |
Function formula | Detail Table: support addition (+), subtraction (-), multiplication (*), and division (/).
|
Variables | Variables for formulas are only selected from available fields in the form. |
Added fields are located at the bottom of the fields list and can be deleted and modified:
The data obtained through calculated fields are all numeric. These fields can be added to the display fields in the detail table, and to Dimension and Measure of the Stats. Take a detail table as an example:
Step 5 Copying Calculated Fields
When the calculation content is similar, you can copy the added calculation field, and then make certain modifications to figure out a new measure.
Step 6 Updating Calculated Fields
You can clickto update the edited calculation formula or field name.
Step 7 Deleting Calculated Fields
You can also delete unwanted calculated fields:
I have finished reading. 🏆
👉I can't wait to Try for myself.
👉I need more HELP in Discord Forum.