A calculated field creates a new value in Tableau from existing columns. It is how you turn raw sales and cost figures into profit, margin or a flag for late deliveries.
Creating one
- Right-click a field in the Data pane, or choose Create Calculated Field.
- Give it a clear name, such as Profit Margin.
- Write the formula, for example (Profit / Sales).
- Click OK and drag the new field onto the view.
Three things to check
- Does the formula return the right result for one row you can check by hand?
- Does the aggregation match the chart? A sum of ratios can give a wrong answer.
- Is the field name clear to the next person reading the dashboard?
For the wider tool set, read Power BI vs Tableau for beginners or see the Power BI course page. Book a free demo class, and ask a counsellor for the current course.
