📊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 and quantity columns, the formula SUM(cost) / SUM(quantity) would yield the average cost per item.

• Or if you have a table of orders with price and quantity, AVERAGE(price * quantity) would give you the average size of the orders.