Percentage of total

The Percentage of total step helps you calculate the relative proportion of each value within a total, optionally within specified groups. It's essential for understanding the composition of your data and relative contributions.

Step parameters

• Value Column column (string)*: The column that will be used for the computation.

• Group By column (string)* (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.

• New column name string (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

Input

Compute - percentage of total input

Configuration

{
    "column": "sales",
    "group_by": [],
    "new_column_name": "sales_percentage"
}

Output

Compute - percentage of total output