πPivot Tables
Arcwise supports pivots on data tabs. To create a pivot follow the steps below.
1) Navigate to the Arcwise Connected Data tab you would like to do a pivot on.

2) From the Add next step menu at the bottom left corner select Add pivot transform.

3) Add the filters, columns, rows, and value you want in the pivot and Preview the result

4) When the result looks correct click the green Connect button in the bottom right corner.
Supported Formulas and Aggregations
Similar to column-level formulas, for pivots we support a subset of the built-in Sheets functions and most common arithmetic expressions. You can also use SQL functions.
List of officially supported functions
Aggregation functions
SUM
COUNT, COUNTUNIQUE
AVERAGE
MIN, MAX
MEDIAN, MODE
STDEV, STDEVP
VAR, VARP
CORREL
COVAR, COVARIANCE.P
Math functions: ACOS ASIN ATAN COS COT DEGREES EXP FLOOR LEFT LEN LN LOG LOG10 LOWER MOD PI POWER RADIANS REGEXEXTRACT RIGHT SIGN SIN SQRT TAN TRIM UPPER
Examples
Assuming your table has
cost
andquantity
columns, the formulaSUM(cost) / SUM(quantity)
would yield the average cost per item.Or if you have a table of orders with
price
andquantity
,AVERAGE(price * quantity)
would give you the average size of the orders.
Last updated