How do I create a calculated column without formulas?

In Dotwave you describe the new column in plain English, such as ‘profit margin = (revenue minus cost) divided by revenue’. Dotwave generates a safe, typed calculation, runs it across your full dataset and adds the new field — no spreadsheet formulas or SQL.

What kinds of calculations are supported?

Arithmetic between columns, date parts such as extracting the year or month, bucketing numbers into ranges, and rolling windows like a 7-day average. Each calculation is validated and added as a reversible step.

Calculated fields

Create new metrics by describing them.

Profit margin, year-over-year change, date buckets, rolling averages — describe what you need in plain English. Dotwave adds it as a new column in your cleaned dataset.

Real analyst problem

Your client wants profit margin as a column so they can filter by it in their Power BI report. In Excel: write the formula, check for divide-by-zero errors, copy down 5,000 rows, pray it doesn’t break. In Dotwave: type ‘profit margin as profit divided by revenue’. Done.

What kinds of fields can you create?

Arithmetic: add, subtract, multiply, divide columns
Date parts: extract year, month, day, quarter
Bins: group numeric values into categories
Rolling: moving averages, rolling sums
Combine: arithmetic between two columns by name
Concatenate: join text columns together

How it connects to the cleaning pipeline

Calculated fields live in Step 4 — Feature Engineering. Run after cleaning (Steps 1–3) so your new metrics are built on clean, validated data — not the original messy file.

Safe by design

All arithmetic is AST-validated — no arbitrary code execution. Division operations are checked for zero denominators before they run.

Create new metrics by describing them.

What kinds of fields can you create?

How it connects to the cleaning pipeline

Safe by design

Ready to clean your data?