Column’s Statistics

User interface

General Principles Add Missing Dates Add text column Add Total Rows Aggregate Append Compare Text Columns Argmax Argmin Concatenate columns Convert Convert date to text Convert text to date Cumulated sum Custom step Delete column(s) Geographically dissolve data Duplicate Duration Evolution Extract date information Extract substring Fill null Filter Formula Geographical hierarchy Get unique groups/values Hierarchical rollup ifthenelse Join Keep column(s) Moving Average Percentage Pivot Rank Rename Replace Geographical simplification Sort Split column Column's Statistics To lowercase To uppercase Top N rows Unpivot Waterfall

Technical documentation

Packages Steps Designing a new step Known limitations Variables UI components Custom code editor Python package

Column’s Statistics

You can use this step to compute main statistics, like median or quintiles, of a numeric column.

This step is supported by the following backends:

Mongo 5.0
Mongo 4.2
Mongo 4.0
Mongo 3.6

Where to find this step?

Column header menu
Widget Compute
Search bar

Options reference

Choose the column to compute the statistics. This column must be of type ‘float’ or ‘integer’.
Optionally, you can split the result by other columns values.
Check statistics to compute.
You can also in the “custom quantile” section define quantiles. For instance, the median is the 1st 2-quantile.

Examples

Basic example

This configuration results in:

With a group column

This configuration results in:

Defining a custom quantile

This configuration results in: