Default tables in Dashpivot Web allow users to add unlimited rows, but they do not support built-in calculations such as averages. To calculate the average of a numeric column in a default table, you can use a second prefilled table with a formula that cross-references the default table column. This method ensures the average updates automatically as new rows are added.
Prerequisites
Before you begin make sure you have the following:
Plan: FreeTrial, Standard, Pro, Premium, Platinum
Permission: Org Controller (Home Folder) or Org Controller, Project Controller, Team Controller (Team Folder)
Skills Required: Dashpivot
Device Type: computer
Subscription: Dashpivot Web
Step-by-Step Instructions
Open the form template in edit mode.
Add a Default table to your template if one has not already been added.
Ensure the default table contains a numeric column with the values you want to average.
Add a second table to the template and set it as a Prefilled table.
Click into the cell in the prefilled table where you want the average to appear.
Change the cell type to Formula.
Enter an AVERAGE formula that references the numeric column in the default table. For example:
=AVERAGE(Table1!B:B)Replace
Table1with the name of your default table andB:Bwith the column you want to average.Press Enter to apply the formula.
Save the template.
Note
Default tables do not support calculations directly, so averages must be calculated in a separate prefilled table.
The average will automatically update as new rows are added to the default table.