Percentage

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

Percentage

Compute the percentage of total as the share of every row in the column total. The computation can be performed by group if specified (i.e. the percentage of total will be computed inside every group, as the share of every row in the total of its group).

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?

Widget Compute
Search bar

Options reference

Value column...: The column that will be used for the computation
Group by... (optional): if you want the computation to be segmented by group, you can select one or several columns that will be used to constitute unique groups (equivalent to the columns that you would specify after the GROUP BY clause in SQL or in the _id field of a $group in Mongo aggregation pipeline)
New colum name: (optional): if you want to give a custom name to the column of results to be created. By default, it will be your original column name suffixed by ‘_PCT’.

Example

This configuration results in: