- Go to the top menu, select ‘Analysis,’ then click ‘Create Calculated Field.’
- Enter AVG([your field]) in the formula box. Then click 'OK'. In this tutorial, we will calculate the average sales. Formula: AVG(SALES)
- Change the field name to ‘Average Sales.’
- Your aggregate data will appear in the Data pane.
- You can drag your aggregate data to the Rows or Columns shelf along with your other fields to view the Average data.
How to Calculate Average in Tableau
Try this guided demo to learn how to calculate average in Tableau.
📌 Why this matters
Calculating averages through custom fields gives you flexibility that built-in summary statistics can't match. You can create contextual averages that adapt to your specific filter selections and dimensional breakdowns, rather than being locked into static values. This becomes particularly powerful when building dashboards where users need to see how individual records compare to relevant peer groups. Your average calculations automatically recalculate as viewers interact with filters, providing dynamic benchmarks that reveal performance patterns across different segments of your data.
Your product deserves an interactive demo
