- Tableau Tutorial
- Tableau - Home
- Tableau - Overview
- Tableau - Environment Setup
- Tableau - Get Started
- Tableau - Navigation
- Tableau - Design Flow
- Tableau - File Types
- Tableau - Data Types
- Tableau - Show Me
- Tableau - Data Terminology
- Tableau Data Sources
- Tableau - Data Sources
- Tableau - Custom Data View
- Tableau - Extracting Data
- Tableau - Fields Operations
- Tableau - Editing Metadata
- Tableau - Data Joining
- Tableau - Data Blending
- Tableau Worksheets
- Tableau - Add Worksheets
- Tableau - Rename Worksheet
- Tableau - Save & Delete Worksheet
- Tableau - Reorder Worksheet
- Tableau - Paged Workbook
- Tableau Calculations
- Tableau - Operators
- Tableau - Functions
- Tableau - Numeric Calculations
- Tableau - String Calculations
- Tableau - Date Calculations
- Tableau - Table Calculations
- Tableau - LOD Expressions
- Tableau Sort & Filters
- Tableau - Basic Sorting
- Tableau - Basic Filters
- Tableau - Quick Filters
- Tableau - Context Filters
- Tableau - Condition Filters
- Tableau - Top Filters
- Tableau - Filter Operations
- Tableau Charts
- Tableau - Bar Chart
- Tableau - Line Chart
- Tableau - Pie Chart
- Tableau - Crosstab
- Tableau - Scatter Plot
- Tableau - Bubble Chart
- Tableau - Bullet Graph
- Tableau - Box Plot
- Tableau - Tree Map
- Tableau - Bump Chart
- Tableau - Gantt Chart
- Tableau - Histogram
- Tableau - Motion Charts
- Tableau - Waterfall Charts
- Tableau Advanced
- Tableau - Dashboard
- Tableau - Formatting
- Tableau - Forecasting
- Tableau - Trend Lines
- Tableau Useful Resources
- Tableau - Question Answers
- Tableau - Quick Guide
- Tableau - Useful Resources
- Tableau - Discussion
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Tableau - Numeric Calculations
Numeric calculations in Tableau are done using a wide range of inbuilt functions available in the formula editor.
In this chapter, we will see how to apply calculations to the fields. The calculations can be as simple as subtracting the values of two fields or applying an aggregate function to a single field.
Following are the steps to create a calculation field and use numeric functions in it.
Create Calculated Field
While connected to Sample-superstore, go to the Analysis menu and click ‘Create Calculated Field’, as shown in the following screenshot.
Calculation Editor
The above step opens a calculation editor which lists all the functions that is available in Tableau. You can change the dropdown value and see only the functions related to numbers.
Create a Formula
To study the difference between profit and discount for different shipping mode of the products, create a formula subtracting the discount from the profit as shown in the following screenshot. Also, name this field as profit_n_discount.
Using the Calculated Field
The above calculated field can be used in the view by dragging it to the Rows shelf as shown in the following screenshot. It produces a bar chart showing the difference between profit and discount for different shipping modes.
Applying Aggregate Calculations
In a similar manner as above, you can create a calculated field using aggregate function. Here, create AVG(sales) values for different ship mode. Write the formula in the calculation editor as shown in the following screenshot.
On clicking OK and dragging the Avg_Sales field to the Rows shelf, you will get the following view.
