Compute statistics

The Compute statistics step provides key statistical measures for your numeric data, such as median and quintiles. It's crucial for understanding the distribution of your data and identifying important thresholds or benchmarks. These operations collectively enable you to transform raw data into meaningful insights, prepare your dataset for various types of visualizations, and create a more comprehensive and informative dashboard.

Step parameters

• Column column(string)*: Select the column to compute statistics on.

• Group By Columns string(array) (optional): Select columns to group the data by before calculating statistics.

• Basic statistics checkbox["count", "average", "min", "max", "median"]: Choose a basic statistic to compute.

• Advanced statistics: checkbox["standard deviation", "variance", "first quartile", "last quartile", "first decile", "last decile", "first centile", "last centile"]: Choose an advanced statistic to compute

• Custom Quantiles checkbox: Specify custom quantiles to calculate, including label, nth value, and order.

Example

Input

Compute - Compute statistic input

Configuration

{
    "column": "sales",
    "group_by": [],
    "basic_statistics": ["count", "max", "min", "average"],
    "adv_statistics": ["standard_deviation"]
    "cust_quant": []
}

Output

Compute- Compute statistic output