6 Specific Dimensions for Table Calculations When explicitly defining which way we want table calculations to be performed, we can use the words FOR EACH and BY(ACROSS) to help us better understand which attributes are checked and which are not. Which of the following is TRUE in the below example? Table Calculation % Difference Null if there are not enough values Compute Using Table (down) Pane (down) Pane (across then down) Pane (down then across) Cell Specific Dimensions Date Symbol At the level Deepest Restarting every Sort order Specific Dimensions Show calculation assistance FOR EACH date calculate % Difference FOR EACH symbol FOR EACH symbol calculate % Difference BY(ACROSS) date(s) FOR EACH date calculate % Difference BY(ACROSS) symbol FOR EACH symbol calculate % Difference FOR EACH date 7 Order of Operations Review Later Tableau's Order of Operations defines the order in which calculations and filters are applied. This is an essential learning point of this tool. Data Source Filters Context Filters Top N, Sets, Conditional Filters & Fixed LOD 1:00:00 Dimension Filters Include/ Exclude LOD, Data blending Measure Filters Table Calcs, Totals, Forecasts Table Calc Filters Drag the points to the correct definitions: Context Filters A. Defines the data available to the worksheet Dimension Filters B. Defines the data available to visual window Table Calculation Filters C. Hides datapoints from the visual window Regular Calculations D. Are calculated using data in the window Table & Window Functions E. Are calculated using data in the window Level of Detail Calculations Can loo! the ndow, at all the data in the worksheet context 8 Order of Operations Review Later The Bollinger band visual was difficult to create since the moving average needed to refer to data points outside of the visible window. Data Source Filters Context Filters Top N, Sets, Conditional Filters & Fixed LOD 1:00:00 Dimension Filters Include/ Exclude LOD, Data blending Measure Filters Table Calcs, Totals, Forecasts Table Calc Filters Which of the following descriptions are true? Select ALL that apply. To calculate moving averages in Tableau, it may be necessary to summarize data points that are not visible in the chart. We can change a regular filter into a Table Calculation Filter using LOOKUP. This forces the filter to be applied lower in Tableau's Order of Operations. As a result, this hides data points instead of removing them from the visual window. DateFilter is a Dimension filter, meaning it filters the visual window. By promoting it to a Context filter, our window calculations are able to summarize all the data in the worksheet. The WINDOW_AVG function is a table calculation, and can only summarize data points in the visual window. 9 Level of Detail Calculations Review Later In this case study, we briefly introduced Level of Detail Calculations. Level of Detail Calculations give us extra flexibility to define which data we want to use in our calculation. We used a basic level of detail calculation to expand the calculation to the whole context, instead of just the visual. Which of the following is a Level of Detail calculation? --SUM([Volume])-- {SUM([Volume])} /SUM([Volume])/ 10 Parameters in Visuals Review Later We used parameters to give users additional interactive functionality in our reports. Which of the following are true about parameters used in this way? Select ALL that apply. There are two steps to creating a parameter responsive visual. First, to create the parameter itself, and second to create a measure that responds to it. Parameters are used to change the size of visuals OOO A parameterized filter always applies to all worksheets Parameters can be used to filter, and highlight data points