Calc Panel
The Calc panel lets you quickly calculate statistics for selected rows and columns in the Data editor.
Info
To open the Calc click Panels -> Calc on the Right sidebar or use shortcut.
Select data¶
You can select multiple cells as usual:
- Drag with the left mouse button
- Hold Ctrl or Shift while clicking
The panel updates automatically to show statistics for the selected data.
Group data¶
To group data by columns, click Group by columns
(
) on the toolbar.
Click it again to remove grouping and show summary values for all columns.
Use functions¶
By default, the panel shows Count and Count distinct.
To add more, click Add (
) and choose a function:
| Function | Description |
|---|---|
| Count | Counts all values, including duplicates and nulls. |
| Count distinct | Counts only unique values. |
| Count nulls | Counts how many values in the column are NULL. |
| Sum | Adds up all numeric values. |
| Average | Calculates the mean of all numeric values. |
| Minimum | Returns the smallest value in the column. |
| Maximum | Returns the largest value in the column. |
| Median | Returns the middle value when all values are sorted. |
| Mode | Returns the most frequent value in the column. |
Tip
Click Toggle numbers/strings aggregation (
) to switch between
numeric-only and mixed (numeric and string) aggregation. When it’s off, only numeric columns are included in calculations.
To remove a function, select it and click Remove function
(
) or use the context menu.
To clear all, click Reset (
).
Copy results¶
You can copy results in two ways:
- Copy value - copies a single function result
- Copy all - copies all functions with their values
Right-click in the panel to access these options.