Understanding extracts and data source filters
In the previous two sections of this chapter, we learned about live and extract connections. We also looked at both data source and extract filters. In this section, we will look at how they work in more detail:
- Continuing from the previous exercise, notice the top right-hand corner of the canvas, as seen in Figure 10.9:
Figure 10.9 – Extract and data source filters
- When an extract is selected, we notice that Tableau will tell us when the extract was last run and if it includes all or some of the data from the underlying data source. Clicking on Refresh will load our extract based on the settings that we specify in the extract settings dialog. Clicking on Edit will take us to that dialog, as we detailed in the previous section. One of the options in the dialog box is to filter the rows in the extract based on one or more fields, as illustrated in step 5 of the exercise in the previous...
