This guide explains how to calculate the average (mean) of a range of numbers at the bottom of a Prefilled Table in Dashpivot Web. Prefilled Tables have a fixed number of rows defined in the template, allowing you to place an average calculation directly in a formula cell by using Dashpivot’s AVERAGE() function.
Prerequisites
Before you begin make sure you have the following:
Plan: Standard, Pro, Premium, or Platinum
Permission: Org Controller (Home Folder) or Org Controller, Project Controller, Team Controller (Team Folder)
Skills Required: Dashpivot, Excel formula knowledge
Device Type: computer
Subscription: Dashpivot Web
Step-by-Step Instructions
Open your template and navigate to the Prefilled Table where you want to display the average.
Identify the range of cells you want to average (e.g., cells containing numeric values).
Select the formula cell at the bottom of the column where you want the average to appear.
Enter the
AVERAGE()formula referencing the range. For example:=AVERAGE(A1:A4)
This calculates the average of values from A1 to A4, including all numbers in between.
Example
The general syntax for averaging a range is:
=AVERAGE(Number1:Number2)
Where:
Number1 is the first cell in the range,
Number2 is the last cell in the range.
In the example where the values are:
A1 = 10
A2 = 15
A3 = 20
A4 = 25
Then
=AVERAGE(A1:A4)returns 17.50.