AI Data Analysis Tutorial

update

2025.06

Exclude Outliers

Treat Blanks as 0

* round to 2 decimals

Highlight Outliers

Existing Calculated Columns

Column Name	Formula	Actions

Modified Columns

Column Name	Applied Formula	Actions

Add New Column

Modify Column

Outlier Settings

New Column Name

Formula

Use column names in brackets like [Column Name]. Supports +, -, *, /, and parentheses.

Available Columns

Formula Preview

Overall average for ratios

When checked, ratio column averages are calculated as (sum of numerators) / (sum of denominators).

Display result as percentage

When checked, the calculated value will be multiplied by 100 and displayed with % symbol.

Select Column

Outlier Conditions

value <

Values below this are outliers

value >

Values above this are outliers

Custom Outlier Settings: Set min/max thresholds to define outliers. Leave empty for no limit.
System Default: If no custom settings are configured, automatic outlier detection will be applied.

Current Outlier Settings

Column	Min (<)	Max (>)	Actions
No outlier settings configured

Color Customization

Preview

Select chart options to see preview

Period Selection