![4
Mastering Calculated Fields
Types of Calculated Fields
1. Basic Arithmetic Calculations:
• Example: Calculate total cost as ‘Cost’ * ‘Quantity’.
• Usage: Creating new numerical measures like total expenses, discounts, or growth rates.’
2. String Manipulations:
• Example: Combine ‘First Name’ and ‘Last Name’ into a full name using ‘First Name’ + ' ' + ‘Last Name’.
• Usage: Formatting and concatenating text fields, extracting parts of strings.
3. Date Calculations:
• Example: Calculate the age of a record using DATEDIFF('year', [Birth Date], TODAY()).
• Usage: Working with dates to calculate durations, age, or future/past dates.](https://image.slidesharecdn.com/session3-250228232720-4f9de9ce/85/DATA-VISUALIZATION-USING-TABLEAU-PROGRAME-4-320.jpg)
![5
Mastering Calculated Fields
Types of Calculated Fields
4. Logical Calculations:
• Example: Create a field to categorize sales as ’IF [Sales] > 10000 THEN 'High' ELSE 'Low' END’.
• Usage: Conditional statements to create flags, segments, or categories based on data conditions.
5. Aggregate Calculations:
• Example: Calculate average sales per customer using ’SUM([Sales]) / COUNTD([Customer ID])’.
• Usage: Aggregating data to find averages, totals, or distinct counts.
6. Level of Detail (LOD) Expressions:
• Example: Calculate the average sales per region regardless of the view's filters using ’FIXED [Region] : AVG([Sales])’.
• Usage: Controlling the level of aggregation to create measures at different levels of detail.](https://image.slidesharecdn.com/session3-250228232720-4f9de9ce/85/DATA-VISUALIZATION-USING-TABLEAU-PROGRAME-5-320.jpg)
![6
Mastering Calculated Fields
• Profitability Index:
• (SUM([Sales]) - SUM([Cost])) /
SUM([Cost])
• Customer Engagement Duration:
DATEDIFF('month’
• , MIN([First Purchase Date])
• ,MAX([Last Purchase Date]))
Examples:](https://image.slidesharecdn.com/session3-250228232720-4f9de9ce/85/DATA-VISUALIZATION-USING-TABLEAU-PROGRAME-6-320.jpg)
More Related Content
Similar to DATA VISUALIZATION USING TABLEAU PROGRAME (20)
Recently uploaded (20)
DATA VISUALIZATION USING TABLEAU PROGRAME
- 1. 1 Data Visualization using Tableau Session 3 Friday, February 28, 2025
- 2. 2 • Advanced Dashboard Techniques in Tableau Agenda
- 3. 3 Mastering Calculated Fields Calculated fields in Tableau are custom fields created by using formulas or expressions to transform existing data or generate new data points. They allow users to perform complex calculations, derive new metrics, and manipulate data directly within Tableau without altering the original data source. Calculated Fields • Custom Formulas: Utilize Tableau’s rich formula language to perform calculations, including arithmetic operations, logical conditions, and text manipulations. • Dynamic Calculation: Calculated fields are recalculated automatically as the data context changes, such as when filters are applied, or dimensions are adjusted. • Versatile Use: Can be used in various places, including rows, columns, filters, marks, tooltips, and more. • Enhance Analysis: Enable deeper insights by deriving new metrics, combining data fields, and creating conditional outputs.
- 4. 4 Mastering Calculated Fields Types of Calculated Fields 1. Basic Arithmetic Calculations: • Example: Calculate total cost as ‘Cost’ * ‘Quantity’. • Usage: Creating new numerical measures like total expenses, discounts, or growth rates.’ 2. String Manipulations: • Example: Combine ‘First Name’ and ‘Last Name’ into a full name using ‘First Name’ + ' ' + ‘Last Name’. • Usage: Formatting and concatenating text fields, extracting parts of strings. 3. Date Calculations: • Example: Calculate the age of a record using DATEDIFF('year', [Birth Date], TODAY()). • Usage: Working with dates to calculate durations, age, or future/past dates.
- 5. 5 Mastering Calculated Fields Types of Calculated Fields 4. Logical Calculations: • Example: Create a field to categorize sales as ’IF [Sales] > 10000 THEN 'High' ELSE 'Low' END’. • Usage: Conditional statements to create flags, segments, or categories based on data conditions. 5. Aggregate Calculations: • Example: Calculate average sales per customer using ’SUM([Sales]) / COUNTD([Customer ID])’. • Usage: Aggregating data to find averages, totals, or distinct counts. 6. Level of Detail (LOD) Expressions: • Example: Calculate the average sales per region regardless of the view's filters using ’FIXED [Region] : AVG([Sales])’. • Usage: Controlling the level of aggregation to create measures at different levels of detail.
- 6. 6 Mastering Calculated Fields • Profitability Index: • (SUM([Sales]) - SUM([Cost])) / SUM([Cost]) • Customer Engagement Duration: DATEDIFF('month’ • , MIN([First Purchase Date]) • ,MAX([Last Purchase Date])) Examples:
- 7. 7 Utilizing Parameters Parameters A parameter is a global placeholder value such as a number, text value, or Boolean value that can replace a constant value in a flow. Instead of building and maintaining multiple flows, you can now build one flow and use parameters to run the flow with your different data sets.
- 8. 8 Utilizing Parameters Purpose of Parameters: Parameters act as placeholders that users can control to manipulate data views dynamically. Case Study Example: A dashboard that allows users to select a region or period, updating visualizations such as sales data and market trends.
- 9. 9 Advanced Filter Actions Filter Actions Filter Actions in Tableau allow users to create interactive dashboards where selecting a data point in one view dynamically filters data in other related views. This interaction enhances the dashboard experience by providing context-sensitive data exploration and seamless navigation between different data perspectives. • Interactivity: Users can click on a specific part of one visualization to filter data displayed in another. • Contextual Filtering: Only data relevant to the selected item(s) is shown in connected views. • Flexible Control: Filter actions can be customized to control which fields and views are affected. • Intuitive Navigation: Provides a natural and intuitive way for users to drill down into details or change the focus of analysis within a dashboard.
- 10. 10 Advanced Filter Actions Functionality: Filter actions provide a powerful way to make dashboards interactive. Practical Application: Set up a dashboard where selecting a product category automatically updates associated metrics like sales trends and profitability. Benefits: Streamlined data exploration and a cohesive user experience across multiple data points.
- 13. 13 Thank You