Advanced Tools

Making your charts dynamic and user-controlled

An introduction to the powerful FIXED calculation

Extend your FIXED LOD knowledge with INCLUDE and EXCLUDE Level of Detail expressions -- understand LOD syntax as a way to 'zoom in' or 'zoom out' from the current view's granularity, and troubleshoot the common 'cannot mix aggregate and non-aggregate' error.

Quick Table Calculations -- Running Total, Difference, and Moving Average.

Create a Tableau workbook that uses advanced features. Your submission should include: at least one parameter that lets viewers control the analysis (e.g., select a metric or date range), and at least one FIXED LOD expression (e.g., { FIXED [Dimension] : SUM([Measure]) }) to compute a metric at a different granularity. (Optional but encouraged: incorporate a Quick Table Calculation, e.g., a Running Total, to reflect all three Advanced Tools techniques taught in this module.) Export as a .twbx file.