Please enable JavaScript.
Coggle requires JavaScript to display documents.
Tableau Training (Calculations (Aggregation and Replication with LOD…
Tableau Training
Calculations
LOD Expressions
FIXED and INCLUDE
Comparison of Average Profits
Average Profit
Using an LOD Expression
LOD Expression Sytax
Intro to Table Calculations
Intro to Table Calculations
Manual Table Calculations
Quick Table Calculations
Field Set
Modifying Table Calculations
Editing the Table Calculation
Compute Using
Referencing Specific Dimensions
Aggregate Calculations
AGG Calculations
Attribute Aggregation
Aggregated versus Record Level Calculations
Date Calculations
Calculate Time Between Dates
Creating Tableau Dates
Logic Calculations
Performance Indicator with Parameter
Logical Conditional Filter
Number Calculations
Data Validation - Nulls to Zeros
Difference from Quota
String Calculations
String Parameters
Splitting Strings
Type Calculations
Data Validation - Check Length
Rounding Down
Conceptual Topics with LOD Expressions
Syntax
Dimension or Measure
LOD Expressions and Filtering
Aggregation and Replication with LOD Expressions
Aggregation or Replication of Results
FIXED - Aggregated Results
FIXED - Replicated Results
FIXED - Disjoint Results
INCLUDE
EXCLUDE
Nested Expression
Nested LOD Expressions
Context of Nested Expressions
Visual Analytics
Drill Down and Hierarchies
Hierarchy Drill Down
Building Hierarchies
Working with Hierarchies
Date Hierarchies
Sorting
Sorting from the Pill
Sorting Across Panes
Clearing Sorts
Pill Type and Sorting Options
Grouping
Grouping with Header
Grouping from Data Pane
Using Grouped Field
Grouping Marks - Visual Grouping
Additional Ways to Group
Parameterized Calculated Groups
Creating and Using Bins
Sets
Working with Sets
IN/OUT versus Members
Sets and Filters
Sets in Hierarchies and Calculations
Creating Sets
Creating Sets from Marks
Creating Sets from a Computation
Combining Sets
Ways to Filter
Ways to Filter
Removing Filter
Using the Filter Shelf
Pill Types and Filtering
Filtering Dimensions
Filtering Measures or Continuous Dimensions
Filtering Continuous Dates
Filters
Ways to Filter
Removing Filter
Ways to Filter
Using the Filter Shelf
Filtering Continuous Dates
Filtering Measures or Continuous Dimensions
Pill Types and Filtering
Filtering Dimensions
Parameters
Using Parameters
Parameters with Filters
Parameters with Sets
Parameters with Calculated Fields
Parameters with Reference Lines
Parameter Types
Forecasting
Creating a Forecast
Describing the Forecast
Constraints on Forecasting in Tableau
Forecast Fields
Clustering
k-means Clustering Analysis
Using Clustering
Working with Clustering
Conditions for Clustering
Connecting to Data
Managing Data
Editing Meta Data
Editing Data Connections
Managing Extracts
Using Extracts
Refreshing Extracts
Creating Extracts
Changing Data Sources
Data Prep with Text and Excel Files
Pivot
Metadata Grid
Split
Custom Split
Join Types with Union
Inner Joins
Left Joins
Right Joins
Outer Joins
Union
Cross Database Joins
Cross-database joins
Using Integrated Data Sources
Additional Data Blending Topics
Working with Aggregated Data in Calculations
Working with Null Values
Asterisk when Blending
Asterisks Solution
Why is Tableau Doing That?
Understanding Pill Types
Dimensions and Measures
Continuous and Discrete
Changing Default Pill Type
Axis vs. Label
Color and Maps
Date Types
Filtering
Aggregation, Granularity, and Ratio Calculations
Aggregation and Granularity
The Detail Shelf
Aggregation in Calculations
Profit Ratio Calculations
Summary
When to Blend and When to Join
One to Many Relationships
Joins inflating the number of rows
Benefits of each other
Fixing Incorrect Sorts
Incorrect Sorts
Rank
Filtering for Top Across Panes
Filtering for the Top 10
Top 10 Using Index()
Top 10 using RANK
Measuring Names and Values
Text Table
A Shortcut
Other Chart Types
Measure Names as Field Labels
Dashboard
Building a Dashboard
Adding Views to a Dashboard
Adding Objects to a Dashboard
Fitting Sheets
Legends and Quick Filters
Filters on Dashboards
Dashboard Layouts and Formatting
Titles and Dynamic Values
Floating Objects
Format Menu
Images and Web Pages
Layout Containers