Introduction
Product Features
Data Import
Data Wrangling
Visualization
- Types
  Pivot
  Summarize Table
  Table
  Bar
  Line
  Area
  Pie/Ring
  Radar
  Histogram
  Density Plot
  Scatter (No Aggregation)
  Scatter (With Aggregation)
  Boxplot
  Violin
  Error Bar
  Error Bar (Summarized Data)
  Map - Standard
  Map - Extension
  Map - Long/Lat
  Map - Heatmap
  Heatmap
  Contour
  Number
  Word Cloud
  Word Cloud (日本語)
- Features
  Trend Line
  Reference Line
  Repeat By
  Window Calculation
  Date/Time Aggregation
  Show Range
  Highlight
  Change Marker
  Multiple Y-Axis Columns
  Layout Configuration
  Column Configuration
  Column Configuration Dialog
  Color and Group Setting
  Color and Group Setting (日本語)
  Color Setting
  User Color Palette Setting
  Pin
  Save as PNG/SVG
  Save as Exploratory Data File
  Share/Schedule
  URL Link
  Category (Binning)
  Highlight
  Limit Values
  'Others' Group
  Edit Display Name
  Missing Value Handling
  Rename Column Names
  Axis Setting
  Axis Formatting
  Show Detail
  Fit to Screen (Table)
  Number of Unique Values Check
  Number of Unique Values Check (日本語)
Analytics
Statistics
Machine Learning
Text Analysis
Extend with R
Setup
Diagnostics
Keyboard shortcuts

Powered by GitBook

On this page

How to Access This Feature
From + (plus) Button
From Column Menu
Summarize by Selecting Aggregate Function from UI
Summarize by Custom R Expression

Was this helpful?

Data Wrangling

Summarize (Aggregate)

PreviousCreate New Calculation for Multiple Columns NextGroup

Last updated 3 years ago

How to Access This Feature

From + (plus) Button

Click "+" button and select "Summarize (Aggregate)".

From Column Menu

You can also select "Summarize (Aggregate)" from column menu of the column to aggregate, and then select its submenu to choose the type of aggregation.

Summarize by Selecting Aggregate Function from UI

(Optional) Select column(s) for "Group By".
Select Value column(s) to to aggregate its values.
Select aggregate function to apply to each column.
Click "Run" to run the aggregation and create the new column.

Summarize by Custom R Expression

Select "(Custom)" from a Column List of Values.
On the Custom Dialog, type in the R Expression for the aggregation in "Expression" field.
Type in the name of new column with aggregation result in "New Column Name" field.
Click "OK" on the Custom Dialog and check the preview result.
Click "Run" to run the aggregation and create the new column.