FIXED and EXCLUDE

The first playground we will build will be for the purpose of exploring two of the three LOD functions: FIXED and EXCLUDE. We will use a set of parameters and associated calculated fields to efficiently explore how these functions work.

Setting up the workbook

Much of the groundwork for this exercise has already been completed in the workbook associated with this chapter. The following steps will simply require you to open different calculations and parameters to see how they have been set up and why this works. Explanations are given along the way. If you do not have ready access to the workbook, you should be able to construct a similar one by referencing the following steps.

To complete the initial setup of a worksheet, take the following steps:

1. Navigate to https://public.tableau.com/profile/marleen.meier to locate and download the workbook associated with this chapter.
2. Open the workbook associated with this chapter and navigate to...