A lot of business data follows patterns, both in the sense that the data reflects daily, monthly, or quarterly trends, or that it contains similar values for related items. For example, the product name for a specific type of bike might include the word “trail”. In this movie, I’ll show you how to limit your display to values that follow a specific pattern by using wildcards in your filters.
- [Narrator] A lot of business data follows patterns, both in the sense that the data reflects daily, monthly, or quarterly trends, or that it contains similar values for related items. In this movie, I will show you how to build on those patterns in your data by creating wildcard filters. My sample file is the workbook named Wildcard Filter, and you can find it in the Chapter Six folder of your exercise files collection. I have a highlight table here, which indicates the relative magnitude of the values in my values field.
Let's say that I want to filter those values so that I only see certain ones. The first thing I need to is to create a filter. I want to filter by Property City, which is the list of cities I have here. So, I will go to the Data tab, and I will click Property City's down arrow, and click Show Filter. Doing so adds that field to the filters area. Now I can double-click it to open the Filter dialogue box, and I'll drag over to the side.
If I want to use a wildcard that is a pattern, then I can click the Wildcard tab. And here I have a number of options. First is that I can look for values that contain a certain string that Start with, End with, or Exactly match. I'll start with Start with, so I will select that option. And let's say that I only want to see cities that begin with the letter P. So I'll click in the Match value box and type the letter P, and click Apply, and you can see that I have Philadelphia, Phoenix, and Portland.
Also note that in this case the match is not case sensitive, so even though I typed a lowercase P, I'm still getting all the values that start with capital P's. If I want to get rid of the filter, I can click Clear, and Apply, and there it is. If I wanted to do Ends with, then I could select Ends with, and if I want to match values that end with the letter S, I'll click that, or type the S in the Match value box, click Apply, and I see Dallas, Las Vegas, Los Angeles, and New Orleans.
And I'll click Clear and Apply to get rid of that. Exactly match is basically a search for an individual value, so if I click Exactly matches, and then type Boston, and Apply, I see only Boston. But if I were to type B-O-S, and click Apply, then I wouldn't see anything because nothing matches it. And I'll go ahead and click Clear and Apply again. Now say that I want to use Contains. Contains looks for a string or a single value anywhere within the field that we're filtering.
So, for example, if I were to click the Contains option, and then go into Match value, and type in A, and Apply, then I would only see cities that have an A in the name. If I want to exclude cities that have an A in its name, then I could check the Exclude box, and I also see Does not contain, Does not start with, and so on, and click Apply, and I see Boston, Denver, New York, Phoenix, and Richmond, which are the only cities that don't have an A anywhere in their name.
I can click Clear and Apply to get rid of the filter, and clear the Exclude check box so that it's no longer being applied. When you're done applying your filter, you can either Reset to go back to the original, click Cancel to stop any filtering that you don't want to apply, or click OK to close the dialogue box, and leave the existing filter in place. Any time that you need to filter your database on a pattern, be sure to go to the Wildcard tab, and you'll be able to narrow down to the values you want.
Author
Updated
5/10/2017Released
10/13/2016- Managing data sources and visualizations
- Managing Tableau worksheets and workbooks
- Creating custom calculations and fields
- Analyzing data using statistical tools
- Sorting and filtering Tableau data
- Defining groups and sets
- Creating and pivoting crosstabs
- Formatting Tableau visualizations
- Creating basic charts
- Annotating and formatting charts
- Mapping geographic data
- Creating dashboard and actions
Skill Level Intermediate
Duration
Views
Q. This course was updated 5/10/2017. What topics were part of the update?
A. Topics related to version 10.1 and 10.2 were part of the course update.
Related Courses
-
Creating Interactive Dashboards in Tableau (2015)
with Nate Makdad1h 37m Intermediate -
Tableau 10 for Data Scientists
with Matt Francis2h 24m Intermediate
-
Introduction
-
Welcome59s
-
-
1. Introducing Tableau
-
Downloading Tableau2m 36s
-
Installing Tableau drivers2m 15s
-
Getting help in Tableau2m 2s
-
-
2. Managing Data Sources and Visualizations
-
Connecting to a data source1m 56s
-
Joining related data sources3m 27s
-
Cleaning up source data2m 37s
-
-
3. Managing Tableau Worksheets and Workbooks
-
Saving your changes2m 24s
-
Creating a packaged workbook1m 33s
-
4. Creating Custom Calculations and Fields
-
Creating a calculated field3m 21s
-
Adding a table calculation3m 46s
-
5. Analyzing Data Using Statistical Tools
-
Displaying the Summary Card2m 30s
-
Forecasting future values3m 58s
-
6. Sorting and Filtering Tableau Data
-
Creating a selection filter2m 58s
-
Creating a wildcard filter3m 50s
-
Creating a condition filter2m 53s
-
Creating a top filter2m 46s
-
7. Defining Groups and Sets
-
Defining a group1m 55s
-
Defining a set2m 14s
-
Combining sets3m 31s
-
Editing and deleting sets1m 37s
-
-
8. Creating and Pivoting Crosstabs
-
Creating a crosstab3m 20s
-
Unpivoting a crosstab1m 50s
-
-
9. Formatting Tableau Visualizations
-
Resizing a visualization3m 39s
-
10. Creating Basic Charts
-
Creating pie charts3m 45s
-
Creating scatter plots3m 19s
-
Identifying data clusters3m 54s
-
Creating histograms3m 6s
-
Creating a treemap3m 26s
-
11. Annotating and Formatting Charts
-
Adding a text box to a chart2m 25s
-
-
12. Mapping Geographic Data
-
Creating a basic map4m 24s
-
Setting map options3m 46s
-
Defining custom regions3m 57s
-
13. Creating Dashboards and Actions
-
Creating a dashboard3m 54s
-
Defining a filter action2m 40s
-
Defining a highlight action3m 44s
-
Defining a URL action2m 36s
-
-
14. What's New in Tableau 10.1 and 10.2
-
Export data to CSV files1m 20s
-
Scale maps dynamically1m 34s
-
Conclusion
-
Further resources1m 17s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Creating a wildcard filter