- Tableau - Data Terminology
- Tableau - Show Me
- Tableau - Data Types
- Tableau - File Types
- Tableau - Design Flow
- Tableau - Navigation
- Tableau - Get Started
- Tableau - Environment Setup
- Tableau - Overview
- Tableau - Home
Tableau Data Sources
- Tableau - Data Blending
- Tableau - Data Joining
- Tableau - Editing Metadata
- Tableau - Fields Operations
- Tableau - Extracting Data
- Tableau - Custom Data View
- Tableau - Data Sources
Tableau Worksheets
- Tableau - Paged Workbook
- Tableau - Reorder Worksheet
- Tableau - Save & Delete Worksheet
- Tableau - Rename Worksheet
- Tableau - Add Worksheets
Tableau Calculations
- Tableau - LOD Expressions
- Tableau - Table Calculations
- Tableau - Date Calculations
- Tableau - String Calculations
- Tableau - Numeric Calculations
- Tableau - Functions
- Tableau - Operators
Tableau Sort & Filters
- Tableau - Filter Operations
- Tableau - Top Filters
- Tableau - Condition Filters
- Tableau - Context Filters
- Tableau - Quick Filters
- Tableau - Basic Filters
- Tableau - Basic Sorting
Tableau Charts
- Tableau - Waterfall Charts
- Tableau - Motion Charts
- Tableau - Histogram
- Tableau - Gantt Chart
- Tableau - Bump Chart
- Tableau - Tree Map
- Tableau - Box Plot
- Tableau - Bullet Graph
- Tableau - Bubble Chart
- Tableau - Scatter Plot
- Tableau - Crosstab
- Tableau - Pie Chart
- Tableau - Line Chart
- Tableau - Bar Chart
Tableau Advanced
Tableau Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Tableau - Date Calculations
Dates are one of the key fields which is extensively used in most of the data analysis scenarios. Hence, Tableau provides a large number of inbuilt functions involving dates. You can carry out simple date manipulations such as adding or subtracting days from a date. You can also create complex expressions involving dates.
Following are the steps to create a calculation field and use date functions in it.
Create Calculated Field
While connected to Sample superstore, go to the Analysis menu and cpck ‘Create Calculated Field’, as shown in the following screenshot.
Calculation Editor
The above step opens a calculation editor, which psts all the functions available in Tableau. You can change the dropdown value and see only the functions related to Date.
Create a Formula
Now, find out the sales volume along with the difference in the date of sales in months from 21st March 2009. For this, create the formula as shown in the following screenshot.
Using the Calculated Field
Now to see the created field in action, you can drag it to the Rows shelf and drag the Sales field to the Columns shelf. Also drag the ship Date with months. The following screenshot shows the Sales values.
Advertisements