This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

Table of contents

• Select data
• Group data
• Use functions
• Copy results

The Calc panel lets you quickly calculate statistics for selected rows and columns in the Data editor.

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.