Analysis for Tableaus
Analysis in Tableau goes beyond dragging fields by adding calculations and analytics. Calculated fields use functions such as IF, DATEDIFF and SUM, level of detail expressions like FIXED control aggregation grain, and table calculations, parameters, sets, reference lines and forecasting add deeper insight to a worksheet.
Stage: Visual Analysis · Part of the Tableau roadmap · Last reviewed 19 November 2026
What to learn in Analysis
- Write a calculated field using IF and CASE logic
- Use a FIXED level of detail expression for customer-level totals
- Apply a table calculation such as running total or percent of total
- Create a parameter that lets viewers switch a measure
- Add reference lines and trend lines to a view
- Group values with sets to compare segments
Analysis interview questions
What is a level of detail expression in Tableau?
An LOD expression, such as FIXED, INCLUDE or EXCLUDE, computes an aggregation at a specified granularity independent of the dimensions in the view. For example, FIXED [Customer] : SUM([Sales]) gives each customer's total.
How is a table calculation different from a calculated field?
A table calculation runs on the aggregated results already in the view, such as running total or rank, and depends on partitioning and direction. A regular calculated field is computed row by row or aggregated in the data source query.
Where Analysis fits in the Tableau roadmap
Analysis belongs to the Visual Analysis stage (beginner level). Build charts.
Other units in this stage
Back to the full Tableau roadmap