Just like Excel Pivot tables, Savant's Pivot Tool allows users to transform data from a row-based format to a more structured tabular layout. Each distinct value of the 'Pivot field' will become a new column in the output, while the 'Value Field' and chosen aggregation will determine what values are displayed in those new columns.
About Pivot Tables
A pivot table is an interactive way to quickly summarize large amounts of data. You can use a pivot table to analyze numerical data in detail, and answer unanticipated questions about your data. A pivot table is especially designed for:
Querying large amounts of data in many user-friendly ways.
Subtotaling and aggregating numeric data, summarizing data by categories and subcategories, and creating custom calculations and formulas.
Expanding and collapsing levels of data to focus your results, and drilling down to details from the summary data for areas of interest to you.
Moving rows to columns or columns to rows (or "pivoting") to see different summaries of the source data.
Filtering, sorting, grouping, and conditionally formatting the most useful and interesting subset of data enabling you to focus on just the information you want.
Presenting concise, attractive, and annotated online or printed reports.
Add a Pivot tool
1. Navigate to your analysis.
2. Click this icon.
3. Click Pivot.
4. Double-Click to open the Pivot tool in a separate tab. This allows for more in-depth analysis and configuration.
Configuration
Add a Pivot tool to your Canvas.
Click on a field from the available selections in the dropdown for "Pivot field." This field will become the new column header names.
Next, select the "Value field," which will provide the values corresponding to the new column headers.
Depending on the data type of the selected "Value field," the Aggregation dropdown will display different aggregation options.
Finally, click Apply.
Aggregations
String values:
COUNT: Counts the total number of occurrences of string values in the selected field.
COUNT DISTINCT: Counts the number of unique string values in the selected field.
Numeric values:
COUNT: Counts the total number of numeric values in the selected Value field.
COUNT DISTINCT: Counts the number of unique numeric values in the selected Value field.
MIN: Returns the smallest (minimum) numeric value from the selected Value field.
MAX: Returns the largest (maximum) numeric value from the selected Value field.
AVG: Calculates the average (mean) of the numeric values in the selected Value field.
SUM: Calculates the sum of all numeric values in the selected Value field.
STDDEV: Calculates the standard deviation of the numeric values in the selected Value field.
VAR: Calculates the variance of the numeric values in the selected Value field.
MEDIAN: Returns the median value (middle value) from the sorted numeric values in the selected Value field.
Understand Pivoting
